PivotField.VisibleItemsList Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  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("")

See Also