This article describes how to go from a crosstab where there are inconsistent Column n per row...
...to a table that adjusts the bottom Column n to show the maximum column sample size for each column:
Requirements
- A crosstab with a Pick One, Pick Any or Pick Any - Compact in the rows and Column n available in Statistics - Below.
- Missing data in your table whereby the number of respondents that have complete data for all the rows results in a lower Column n in Statistics Below.
Method
1. Select your table.
2. In the toolbar go to Automate > Browse Online Library > Modify Tables or Plots > Show Maximum Column Sample Size in Statistics Below.
3. Press OK.
Note, this rule affects only the Column n and Column Population statistics in Statistics - Below and has no effect on any other statistics in the table.