Example - Suppress Zeros in Rows and Columns in an Existing Report

You are a report writer at The Sample Outdoors Company, which sells sporting equipment. You have a report that compares current year data to previous year data. You want to suppress zeros in the report to make the report more concise. You use the zero suppression tool to set the level of suppression.

Procedure

  1. Open the Sample Outdoors Company Balance Sheet as at Dec. 31, 2012 report.
  2. From the Data menu, click Suppress suppress icon and click Suppression Options.
  3. Under Suppress the following, click Rows and columns.
  4. Under Suppress the following type of values, select the Zero values check box.
  5. Run the report.

    Rows and columns containing zeros are hidden.

    Figure 1. Balance sheet with zero suppression applied in rows and columns
    a crosstab showing YTD assets, liabilities, and equity in 2012 and 2011
Parent topic: Suppress Empty Cells in Dimensional Reporting