Suppress 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.
You can suppress rows, columns, or rows and columns based on divide by zero, missing, and overflow values. Suppressing rows or columns without data gives you a more concise view or your report.
Calculations are performed before suppression is applied. If you have multiple crosstabs or charts, you must select one in order to access suppression options.
Within a list report, suppression applies only to rows and is based on non-grouped data items. If details of a group are null, then the header and footer are also suppressed.
Suppression can also be applied to charts, repeaters, and repeater tables.
Access to the suppression feature depends on the settings in your modeling component, IBM® Cognos® Transformer, IBM Cognos Framework Manager, and IBM Cognos Administration.
Procedure
- From the report object toolbar, click the Suppress icon and click Suppression options.
- Under Suppress, choose what sections to suppress.
- Under Suppress the following, choose which values to suppress.