Crosstab reports allow you to look at the combination of multiple Groupings and Measures to look for particularly meaningful combinations within your data.

In this example, you can see how much new business each sales representative has generated for each month of the year.

Within the report editor, you can drag groupings into the Row drop area and they'll appear along the vertical side of the report. Drag groupings into the Column drop area and they'll appear across the report horizontally. Finally, add measures to the the Measure drop area to choose just what numeric value you're evaluating in the crosstab.

Summary Rows and Columns

By default, crosstabs will aggregate rows and columns so that you have a per row total for all rows and a per column total for all columns. You can turn these summaries off by going to Configuration -> Report Properties -> Formatting and toggling 'No Row Summaries' to on to hide row summaries and toggling 'No Column Summaries' to on to hide column summaries.

Sub Summaries

If you have two column groupings, for example Year and Quarter, you can choose to toggle 'Summarize Columns' under Configuration -> Report Properties -> Formatting to add an additional summary column for each Year. You can use 'Summarize Rows' to do the same for the first row grouping if you have multiple row groupings in your crosstab:

Formatting Properties

The following properties are set in the Report Editor -> Configuration -> Report Properties -> Formatting.

Font Size: Specifies the font size used in rendering the crosstab.
Sort by Row Summaries: If toggled, rows in the crosstab will be sorted based on their summary total.
Zeroes to Empty: If toggled, any measure with a value of zero will be shown instead as a blank cell.
No Row Summaries: If toggled, no summary column will shown for each row as the rightmost column of the crosstab.
No Column Summaries: If toggled, no summary row will shown for each column as the bottom row of the crosstab.
Summarize Rows: If toggled, the crosstab will show a sub summary row for each value of the top row grouping.
Summarize Columns: If toggled, the crosstab will show a sub summary column for each value of the top column grouping.
Row Summary Label: If a value is present here, it will be shown above the row summary column.
Column Summary Label: If a value is present here, it will be shown before the column summary row.
Minimum Column Width: If a value is set here (in pixels), each column will have that value as its minimum width. If you have a large number of values in your Column field, this setting can be useful for ensuring that columns are wide enough to be clear to the user.
Default Measure Alignment: If specified, all measures on the report will be aligned to the specified direction of Left, Center, or Right.
Font Family: If specified, the custom font configured will be used for rendering the list.

Color Scheme Properties

The following properties are set in the Report Editor -> Configuration -> Report Properties -> Color Scheme.

Color Set: This property determines which color scheme is used in the report. When set to Primary or Secondary, it will use the colors defined in your Account Skin in the Account section of the application. If you set the property to None, you can customize the color scheme for the report.