How to Use the Cross Table

• To set up the cross table:

1. Select a filter that represents the column you want to add to your cross table.

2. Drag that filter into the cross table.

   Response: Three drop-targets appear.
   

3. Drop the filter onto the drop-target you want. The first will place the column on the vertical axis, the second will place the column on the horizontal axis, and the third will use the column as the actual numeric values inside the cross-table.
   Note: You can also drag-and-drop the filters to the column selectors. This way you can set up hierarchies, which is a very powerful feature in a cross table.

• To display grand totals for rows or columns:

1. Right-click in the cross table to display the pop-up menu.

2. Select Grand Total for Columns or Grand Total for Rows.

   Response: The selected grand total is displayed in the cross table.

   Comment: You can also make these selections from the Appearance page of the Cross Table Properties.

• To display subtotals for columns:

To display subtotals in the cross table, the vertical axis must be set up as a hierarchy with at least two levels.

1. Right-click in the cross table to open the pop-up menu.

2. Select Subtotals for Columns.

   Response: A submenu is opened. It lists the columns and/or hierarchies currently on the vertical axis of the cross table. The options All and None are also available.

3. Select a column (or level in a hierarchy) for which you want to show subtotals. Select All to display subtotals for all the columns (or hierarchical levels) on the vertical axis of the cross table.

   Response: The selected subtotals are displayed in the cross table.

   Comment: You can also make these selections from the Column Subtotals page of the Cross Table Properties.

• To apply coloring:

See Coloring in Cross Tables and Heat Maps to learn how to set up coloring for cross tables specifically. See Coloring Overview if you want to learn more about coloring in general.

• To change the column width:

1. Place the mouse pointer at the right edge of the column header you want to resize. The cursor changes into a cross with arrows.

2. Adjust the width by holding down the mouse button and moving the mouse horizontally.

   Comment: All value columns will be set to the new size. They cannot be specified separately.

   Note: You can also right-click on the cross table, and select Resize Cells to Fit from the pop-up menu. This will set the value columns to the smallest width possible, where all values are still visible.

• To sort the cross table:

1. Click on the column title or row title by which you wish to sort the cross table.

2. Click again to sort in descending order and a third time to return to the default sort order.

   Comment: When you are sorting a cross table, you always work within the last category of a hierarchy. See Cross Table Properties -  Sorting for an example.

• To mark the cells in an entire cross table category:

1. Press Alt on the keyboard and click on the category title of interest.

   Comment: Clicking on the first category in a hierarchy will mark all rows or columns within this category. Clicking on the last category will only mark the rows or columns in that particular category.

• To create a new cross table:

1. Click on the New Cross Table button on the toolbar, .

   Comment: You can also select Insert > New Visualization > Cross Table from the menu.

   Response: A first attempt to set up a suitable cross table is made by the application.

2. Adjust the cross table to display the categories and measures of your choice.

See also:

What is a Cross Table?

Cross Table Properties