SubtotalHiddenPageItems Element (Microsoft Excel)

Specifies whether hidden page field items are included in row and column subtotals, block totals, and grand totals.

Contained In

PivotTable

Remarks

If <x:SubtotalHiddenPageItems/> is specified, hidden items are included.

Example

See the example in the PivotTable element topic.