This article describes how to go from a crosstab where missing data results in an inconsistent Column Sample Size per row...
...to a table that adjusts the bottom Column Sample Size to ignore the missing data:
- A crosstab with a Nominal, Binary - Multi or Binary - Multi (Compact) in the rows and Column Sample Size 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 Sample Size in STATISTICS > Below.
1. Select your table.
2. Go to Properties > RULES on the object inspector.
3. To apply the rule, select the Plus (+) > Browse Online Library > Modify Whole Table or Plot > Ignore Missing Values in Column Sample Size in Statistics Below > OK.
Note, this rule affects only the Column Sample Size and Weighted Column Sample Size statistics in STATISTICS > Below and has no effect on any other statistics in the table.