This article describes how to go from a crosstab where there are inconsistent Column Sample Sizes per row...
...to a table that adjusts the bottom Column Sample Size to show the maximum column sample size for each column:
- 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 > Show Maximum 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.