This article describes how to go from a crosstab where missing data results in an inconsistent Column n per row...
...to a table that adjusts the bottom Column n to ignore the missing data:
- 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.
1. Select your table.
2. In the toolbar go to Automate > Browse Online Library > Modify Whole Table or Plot > Ignore Missing Values in 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.