PivotField.VisibleItemsList Property (Excel)
Returns or sets a Variant specifying an array of strings that represent included items in a manual filter applied to a PivotField. Read/write.
Version Information
Version Added: Excel 2007
Syntax
expression .VisibleItemsList
expression A variable that represents a PivotField object.
Remarks
This property is applicable to OLAP PivotTables only.
Example
This example shows manual, inclusive filtering in an OLAP PivotTable.
ActiveSheet.PivotTables("PivotTable2").PivotFields("[Customer].[Customer Geography] & _
.[Country]").VisibleItemsList = Array("[Customer].[Customer Geography].[Country].&[Australia]")
ActiveSheet.PivotTables("PivotTable2").PivotFields("[Customer].[Customer Geography] & _
.[State-Province]").VisibleItemsList = Array("")
ActiveSheet.PivotTables("PivotTable2").PivotFields("[Customer].[Customer Geography] & _
.[City]").VisibleItemsList = Array("")
ActiveSheet.PivotTables("PivotTable2").PivotFields("[Customer].[Customer Geography] & _
.[Postal Code]").VisibleItemsList = Array("")
ActiveSheet.PivotTables("PivotTable2").PivotFields("[Customer].[Customer Geography] & _
.[Full Name]").VisibleItemsList = Array("")