Anchor | ||||
---|---|---|---|---|
|
Table of Contents | ||
---|---|---|
|
Overview
There are three types of table layout available:
...
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:
- arrange the items in the order you want them to appear in the Column and Row lists.
- metric items cannot be used in the vertical or horizontal headers; they can only be used in the body of the cross tab table.
- 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.
...
- Two row dimensions are now displayed. As Camp Region is listed first, it is broken up in the table by Gender, the secondary dimension.
- As many dimensions as required can be added to a report.