Conditional suppression behaves as follows:
If an entire row or column meets the criteria specified for conditional suppression, the entire row or column is hidden; if only some of the cells in a row or column meet the criteria specified for conditional suppression, the row or column is not hidden.
Suppressed data is not included in calculations. For example, if you suppress rows 23 and 24 and then calculate a sum for rows 10 through 30, the sum does not include the values in rows 23 and 24.
When evaluating suppression, you can include or ignore the values and calculations in hidden rows and columns. This option is enabled only when the Hide Always check box is selected for the row or column. For instructions on this option, see Controlling the Evaluation of Suppression in Hidden Rows or Columns. Regardless of the setting you select, you can evaluate suppression based on hidden cells when you specifically reference the cells by using the Advanced Options method for conditional suppression.
Hidden cells are ignored when evaluating suppression of a row or column unless they are specifically referenced. The output of the report is based on the condition used. The following example is a report with hidden columns.
The above report design is used to describe three conditional suppression scenarios.
In the following 3 examples, column B is hidden and rows 1, 2, and 3 are selected for conditional suppression.
The first example describes the results when specifying suppression based on missing data. Note that because the condition does not reference the hidden column or a specific cell in the hidden column, the hidden column is ignored:
Suppress Row If: Data Values in Current Row = No Data
The following example describes the results when specifying suppression based on the data cells in the hidden column B. Note that since the condition specifies the hidden column B, Root Beer is not suppressed because cell B2 contains data:
When you use conditional suppression based on attributes, you can suppress formula rows or columns based on the suppression status of other data rows or columns. You can suppress text rows or columns based on the suppression status of other rows and columns.
The following table describes whether suppression is valid when referencing another suppressed data, formula, or text row or column.
