Suppressing Empty Cells

Sparse data may result in crosstabs showing empty cells.

For example, a crosstab that matches employees with products results in many rows of empty values for the revenue measure if the employee does not sell those products. To remove sparse data in an analysis, you can suppress empty cells that contain a null or zero value.