Crosstab

Crosstabs allow a complex data representation and require careful considerations about the column and row selection. Otherwise, you will run into reporting restrictions fast. To start configuration of the crosstab, select a Data Source first.

A Crosstab configuration must be done with at least Columns, Rows, and Values to be meaningful - even though omitting the rows may be desired to only create a summary. The view settings allow more options to being configured:

  • In the Simple Settings, the Columns, Rows, and Values, as well as an optional Data Filter can be configured.
  • The Moderate Settings do not have any additional options.
  • Using the Complex Settings, additional configuration options for columns and rows become available:
    • Suppress If Empty - does not show columns with no content.
    • Suppress Grand Total - the overall sum is not being printed.
    • Totals on Top - the overall sum is added to the top instead of the bottom for rows and left most for columns.