Share via

2.2.5.3.5 Manual Filters

  • Article

A manual filter enables specific pivot items (section 2.2.5.3.3) or OLAP members associated with pivot fields (section 2.2.5.3.2) to be shown or hidden in the PivotTable view (section 2.2.5.3). Manual filtering affects subtotal calculations when pivot fields that have manual filters are located on the row axis, column (1) axis, or page axis (section 2.2.5.3.7.1). The pivot items that are hidden for such pivot fields are not included when calculating subtotals.

At least one BrtBeginSXVI (section 2.4.274) record in the BrtBeginSXVIs (section 2.4.278) collection MUST have the fHidden field equal to 0x0.

Manual filters are applied during PivotTable (section 2.2.5) report calculation prior to any of the other types of filters specified in the following sections. If there are multiple manual filters, they are not applied in a specific order.

Details about manual filtering for pivot fields (section 2.2.5.3.2) on the page axis are covered in section 2.2.5.3.7.1.