Show TOC

To show/hide zeros in rows and columnsLocate this document in the navigation structure

Procedure

  1. Select a cell in the crosstab.
  2. Choose Filter and one of the following options:
    • Suppress Zeros in Rows

      All rows that only contain zeros are removed.

    • Suppress Zeros in Columns

      All columns that only contain zeros are removed.

Results

The zeros are suppressed in rows and/or columns. When zero suppression is active, a check mark is displayed beside the menu item.

To restore the hidden rows and columns, choose Start of the navigation path Filter Next navigation step Suppress Zeros in Rows End of the navigation path or Start of the navigation path Filter Next navigation step Suppress Zeros in Columns End of the navigation path again.

You can also define how zeros should be displayed in the crosstab if they are not hidden.