Conditional Suppression Behavior

Conditional suppression behaves in the following manner:

The above report design is used to describe three conditional suppression scenarios.

Note:

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 image describes the results when specifying suppression based on missing 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:

Suppress Row If: Data Values in Column B = No Data

The image describes the results when specifying suppression based on the data cells in the hidden column B.

The following table describes whether suppression is valid when referencing another suppressed data, formula, or text row or column.

If the Row / Column Type you are suppressing =

And if suppression is based on Row / Column of Type =

Data

Formula

Text

 

Data

Available

Not Available

Not Available

Formula

Available

Not Available

Not Available

Text

Available

Available

Not Available