To create a new cross table:
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.
Adjust the cross table to display the categories and measures of your choice.
To set up the cross table:
Select a filter that represents the column you want to add to your cross table.
Drag that filter into the cross table.
Response: Three drop targets appear.
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 set up a cross table with images from a binary column on an axis:
Right-click in the cross table to display the pop-up menu.
Select Properties.
Click to go to the Axes page.
On the Horizontal or Vertical axis, click on the column selector and choose the column containing binary data.
Click on Label Rendering....
Make sure the binary column is selected in the Column drop-down list of the Label Rendering dialog (only applicable if you have selected more than one column on the axis).
Change Show as to Image.
Click OK.
To set up a cross table with images from the web on an axis:
Right-click in the cross table to display the pop-up menu.
Select Properties.
Click to go to the Axes page.
On the Horizontal or Vertical axis, click on the column selector and choose the column containing the identifier to the image.
Click on Label Rendering....
Make sure the identifier column is selected in the Column drop-down list of the Label Rendering dialog (only applicable if you have selected more than one column on the axis).
Change Show as to Image from URL.
In the Label Rendering dialog, click Settings....
Enter the URL where {$} represents each cell value, so that the resulting URL when the values from the identifier column replaces the {$} points to your image. For example, if the images reside on a network drive which is common for everybody in your company and the identifier column contains the names of the images, then the URL to enter might be Q:\Images\{$}.
Click OK twice.
Right-click in the cross table to display the pop-up menu.
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 in the cross table, the vertical axis must be set up as a hierarchy with at least two levels.
Right-click in the cross table to open the pop-up menu.
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.
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:
Place the mouse pointer at the right edge of the column header you want to resize. The cursor changes into a cross with arrows.
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:
Click on the column title or row title by which you wish to sort the cross table.
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:
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.
See also: