Export (0) Print
Expand All

2.2.5.4.7 Manual Filters

Office

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

Show:
© 2014 Microsoft