2.2.5.4.7 Manual Filters

  • Article

A manual filter enables specific pivot items (section 2.2.5.4.4) or OLAP members associated with pivot fields (section 2.2.5.4.3) to be shown or hidden in the PivotTable report (section 2.2.5). Manual filtering affects calculations when pivot fields (section 2.2.5.4.3) that have manual filters are located on the row axis (section 2.2.5.4.9.2), column axis (section 2.2.5.4.9.3), or page axis (section 2.2.5.4.9.1). The pivot items (section 2.2.5.4.4) that are hidden for such pivot fields (section 2.2.5.4.3) are not included when calculating values for the PivotTable view (section 2.2.5.4).

At least one SXVI record (section 2.4.312) following an Sxvd record (section 2.4.309) MUST have the fHidden field equal to 0x0.

Details about manual filtering for pivot fields (section 2.2.5.4.3) on the page axis (section 2.2.5.4.9.1) are covered in the Page Axis section.