HiddenItemsList Property
Returns or sets a Variant specifying an array of strings that are hidden items for a PivotTable field. Read/write.
expression.HiddenItemsList
expression Required. An expression that returns 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