## Introduction

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:

## 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

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.