Split Crosstab cells to see further subgroup differences

This article provides a step-by-step guide to create a Crosstab slide with cells split to show further subgroup values.

In this example, the number of employees in each Function at each Grade level is shown, split by Gender. If you have seen how to See a count of Records split by subgroup categories with a Crosstab, you can save time by skipping to point 6, below.

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”)

6. Expand the ‘Color by’ option
7. Select “Prop.”
8. Select the property used to split cell values.  (in this example, “Gender” is used)
9. Select your preferred color palette
10. Select the Legend icon to display the legend on your slide

See also:

• 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