Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

PivotField.VisibleItemsList Property

Office 2007
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("")



Community Additions

ADD
Show:
© 2015 Microsoft