Display percentages based on the overall population in a Crosstab

This article provides a step-by-step guide to create a Crosstab slide with cells displaying percentage values based on the overall population.

In this example, the proportion of male and female employees split by grade is shown.

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

1. Ensure the Slide pane is selected
2. Select the property with the subgroup categories required for your Columns (in this example, Gender is selected)
3. Select the property with the subgroup categories required for your Rows (in this example, Grade is selected)
4. Select the cog for the Values options
5. Check “Show as percentage”

To include the heatmap option:

6. Expand the ‘Color by’ options with the down arrow
7. Select “Heat.”
8. Select your preferred color

See also:

• See a count of Records split by subgroup categories with a Crosstab
• Split Crosstab cells to see further subgroup differences
• Display average values (and other calculated values) in a Heatmap Crosstab
• Edit data with the Crosstab slide type
• See which positions are included in aggregate totals
• Slice-and-dice your Charts using Paging