How to Use the Cross Table


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

    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.

  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.
    vis_drop_target_cross_table_y.png vis_drop_target_cross_table_x.png vis_drop_target_cross_table_values.png

  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.

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

  2. Select Properties.

  3. Click to go to the Axes page.

  4. On the Horizontal or Vertical axis, click on the column selector and choose the column containing binary data.

  5. Click on Label Rendering....

  6. 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).

  7. Change Show as to Image.

  8. Click OK.

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

  2. Select Properties.

  3. Click to go to the Axes page.

  4. On the Horizontal or Vertical axis, click on the column selector and choose the column containing the identifier to the image.

  5. Click on Label Rendering....

  6. 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).

  7. Change Show as to Image from URL.

  8. In the Label Rendering dialog, click Settings....

  9. 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\{$}.

  10. Click OK twice.

  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 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.

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.

  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.

  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.

  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.

See also:

What is a Cross Table?

Cross Table Properties