See a count of Records split by subgroup categories with a Crosstab

This article provides a step-by-step guide to create a Crosstab slide with cells displaying the count of Records at the intersection of two subgroups.

In this example, the number of positions in each Function at each Grade level is shown.


The explanation assumes you know how to add a slide and specify the Crosstab slide type (see Analyze and visualize across multiple categories with Crosstabs).

1. Ensure the Slide pane is selected
2. Select the properties which define the subgroup categories required for your
   1. Columns (in this example, Function is selected), and
   2. Rows (in this example, Grade is selected)
3. By default, the count of Records is selected for the Values.

You can specify the order of Columns and Rows. The default order is ascending bucket label order, either numeric or alphabetic depending on the type of property used. In this example, we will reverse the Row order to present the grades in descending order, showing the higher value (more senior) grades at the top:

4. Select the cog for either the Row or the Column setting (in this example, the Row settings)
5. Specify required Sort option (in this example, “By Bucket reversed”)

See also:

• Split Crosstab cells to see further subgroup differences
• Display average values (and other calculated values) in a Heatmap Crosstab
• Display percentages based on the overall population in a Crosstab
• Edit data with the Crosstab slide type
• See which positions are included in aggregate totals
• Slice-and-dice your Charts using Paging