Crosstabs

In a Chart, adding a header on the Data tab creates a Legend Item, for example splitting up a stacked bar chart into segments. If we did the same thing in a table, the data object that you add to the ‘Header’ field will be cross tabbed into columns across the top of the table. A crosstab table is created using the ‘Table’ chart type with the extra field of ‘Header’ that contains the data that you want to pivot on. This a very similar concept to creating a Pivot Table in Excel. When you add a data object to the Header field on the Data tab, this information will remain in view as users scroll down the table.

Open

 Example

The following screenshot shows a table that has Store Region as a Header. This field will be displayed at the top of the table and allows us to quickly see related data for each of the Regions. The Store Region will remain in view when using the scroll bar - this means that users will always be able to see what Region the figures relate to as they scroll.

Open

When a ‘Crosstab’ table has been created, users will have an extra option on the Attributes tab - ‘Row Total Type’.

This option will only be available on Crosstab tables and will allow users to specify a Row total in addition to/ instead of a Column total.

Dimensions & Numbers in Crosstab Tables

Regardless of what order you added objects on the Data screen once you add an object to the Header row any Measures will automatically be displayed on the right-hand side of the table.

In the following screenshot, the Measure ‘Attrition %’ was added as the first column followed by 2 Dimensions. As soon as ‘Gender’ was added to the Header row, Attrition % was displayed as the final column.

The order of objects on the Data screen is not changed and if ‘Gender’ was removed from the Header row, which would convert the crosstab table to a standard table, ‘Attrition %’ would then be displayed as the first column.