How to Show Maximum Column Sample Size in a Table

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:

Requirements

• 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 where the number of respondents that have complete data for all the rows results in a lower Column Sample Size in Statistics > Below.

Method

1. Select your table.
2. Go to Data > Rules in the object inspector .
3. Select Plus (+) > Calculation > Calculate Maximum Column Sample Size in 'Statistics - Below'.
4. Press 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.

Next

How to Use Rules in Displayr