Crosstabs

Crosstabs provide users with the tools to nest multiple fields as rows or columns, select multiple measures and calculations, apply traffic lighting and field formatting on any data and produce tables of results. Charts are easily added alongside Crosstabs by selecting from a range of pre-defined chart types.

To access the Crosstab functionality, click Crosstab on the Menu links panel at the top of the screen.

There are six tabs to navigate when creating a crosstab: Axes, Totals, Layout, Linking, Charting and Run Report. To discard any changes and start again, click the 'New Crosstab' at the far right of the tab bar.

Note: If there are one or more Crosstab templates defined in the Manage Reports screen then a context menu appears with the New Report as the first item and the name(s) of the template(s) following.

As options are selected, a preview of the Crosstab is generated in the selected tab.