Page Comparison

...

Suitable for - Presenting data in a tabular, two dimensional list.

Note: arrange the items in the order you want them to appear in the column list. For example, if you want each row to have a location, headcount and basic pay, in that order, arrange the data items in that order in the Columns list.

...

Suitable for - Presenting data in a vertical format.

Note: arrange the items in the order you want them to appear in the Rows list.

...

The example below displays the total invoiced amount collected in each region, broken down by year. The values at the intersection points of rows and columns show summarised information.

Note:

1. arrange the items in the order you want them to appear in the Column and Row lists.
2. metric items cannot be used in the vertical or horizontal headers; they can only be used in the body of the cross tab table.
3. metrics can be added to either the Columns or Row lists in order to populate the summary body of the table, but if using multiple metrics they must all be added to the one list.

Setting up Cross Tab Tables

{html}<iframe width="700" height="394" src="https://www.youtube.com/embed/Ysj9oQcAsYg?color=white" frameborder="0" allowfullscreen></iframe>{html}

Basic Cross Tab

A basic cross tab table will have only one row dimension, one column dimension and one metric specified.

Drag the dimensions and metrics that you wish to display in your cross tab table. You must have a dimension in both the Column and Row lists, and a metric, for the cross tab report to populate.

...