PivotTable.SubtotalHiddenPageItems Property
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.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property SubtotalHiddenPageItems As Boolean
Get
Set
'Usage
Dim instance As PivotTable
Dim value As Boolean
value = instance.SubtotalHiddenPageItems
instance.SubtotalHiddenPageItems = value
bool SubtotalHiddenPageItems { get; set; }
Property Value
Type: System.Boolean
Remarks
For OLAP data sources, the value is always True.