Suppressing zeros

By hiding erroneous data, it is easier to identify significant results in the worksheet. Assume a worksheet contains this data:

	X	Y	Z
A	0	1	2
B	0	0	0
C	0	3	4
D	0	5	0

If Zero Suppress is applied to rows, then row B is removed:

	X	Y	Z
A	0	1	2
C	0	3	4
D	0	5	0

If Zero Suppress is applied to columns, then column X is removed:

	Y	Z
A	1	2
B	0	0
C	3	4
D	5	0

If Zero Suppress is applied to both rows and columns, then row B and column X are removed:

	Y	Z
A	1	2
C	3	4
D	5	0

You can use Zero Suppress to suppress zeros in a specific row or column, or in a generated Summary Report or analysis sheet. You can use Suppress Zero when using the breakout functions.

Click Zero Suppress to view these options:

• Rows: hide rows in which all cells contain zero values
• Columns: hide columns in which all cells contain zero values
• Undo: display previously suppressed rows or columns
• Suppress Report: suppress zeros in the results of the selected report
• Suppress Sheet: suppress zeros in the results of the current analysis sheet.

The Suppress Zero function is also available from the Report Style tab from the drilldown functions:

• Breakout
• Summary Drilldown
• Transaction Drilldown
• Expand.