Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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

Show: