PivotField.HiddenItemsList Property (Excel)
Returns or sets a Variant specifying an array of strings that are hidden items for a PivotTable field. Read/write.
Syntax
expression .HiddenItemsList
expression A variable that represents a PivotField object.
Remarks
The HiddenItemsList property is only valid for Online Analytical Processing (OLAP) data sources; using this property on non-OLAP data sources will return a run-time error.
Example
The example sets the item list so that only certain items are displayed. It assumes an OLAP PivotTable exists on the active worksheet.
Sub UseHiddenItemsList()
ActiveSheet.PivotTables(1).PivotFields(1).HiddenItemsList = _
Array("[Product].[All Products].[Food]", _
"[Product].[All Products].[Drink]")
End Sub