Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All Manual Filters


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

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 on the page axis (section are covered in the Page Axis section.

© 2015 Microsoft