Suppress Values

You can ignore categories whose values fall into a low range. For example, sales channels that were not active contributors to the bottom line are better left out of the report. You can also ignore categories that either don't apply to the report or that return zero values. In these situations, you can use one or both of the following suppression features:

• Zero suppression removes rows or columns containing all zeros.
• 80/20 suppression removes rows or columns whose absolute values do not contribute to the top 80% of results. It then summarizes the removed rows or columns into a single row or column called "Other."

When you apply 80/20 suppression, the data for the cells is sorted in descending order and a total is made of the absolute values. Then the sorted values are added until the cumulative total is eighty percent of the total. If the last value added to the cumulative total appears in more than one cell, all those cells are considered part of the eighty percent.

In Microsoft SQL Server Analysis Services cubes or SAP BW cubes, if the dynamic rollup of the "Other" category includes a category that is also filtered as a result of the overall 80/20 suppression, a conflict results that causes PowerPlay Web to return an NA value for the "Other" category.

All the suppression buttons remain enabled until you click them again.

Steps to Apply Zero Suppression

1. On the PowerPlay Web toolbar, click the arrow to the right of the zero suppression button .
2. Choose where to apply zero suppression:
   • To apply zero suppression to rows and columns, click Zero Suppression.
   • To apply zero suppression to rows only, click Rows Only.
   • To apply zero suppression to columns only, click Columns Only.

The rows or columns that contain only zeros are removed, and a comment indicating the type of zero suppression applied appears at the bottom of the report.

Steps to Apply 80/20 Suppression

• On the PowerPlay Web toolbar, click the 80/20 Suppression button .

PowerPlay Web shows the total of values suppressed in an additional row or column called "Other" and shows "80/20 suppression" at the bottom of the report page. If a category labelled "Other" is not shown, all the categories in the report dimension contribute to eighty percent of the total.