True if hidden page field items in the PivotTable report are included in row and column subtotals, block totals, and grand totals. The default value is False. Read/write Boolean.
For OLAP data sources, the value is always True.
This example sets the first PivotTable report on worksheet one to exclude hidden page field items in subtotals.
Worksheets(1).PivotTables("Pivot1").SubtotalHiddenPageItems = True