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.
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.
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:
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: