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
- Select your table.
- In the toolbar, go to Automate > Browse Online Library > Modify Tables or Plots > Calculate Maximum Column Sample Size in 'Statistics - Below'.
- 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.