FilterMembers Property

See Also                  Applies To

Returns or sets a list of members to be used in a filter operation. Read/write Variant.

Remarks

You can set this property when a field is used on the row, column, or data axis. If this property is set for a field on the data axis, the field is used to filter the detail records but not the members and aggregates. If this property is set on a field on the summary axis, the field is used to filter the detail records and aggregates.

You can set this property by using a Variant array of PivotMember objects or string member identifiers (retrieved by using the Caption, Name, or UniqueName property), as shown in the following examples.

This example uses an array of String values.

PivotTable1.ActiveView.ColumnAxis.Fieldsets("State").Fields(0).FilterMembers = Array("WA", "OR")

This example uses an array of objects.

Set tmpMemberCol = PivotTable1.ActiveView.Fieldsets("State").Members(0).ChildMembers("WA")
Set tmpMemberRow = PivotTable1.ActiveView.Fieldsets("State").Members(0).ChildMembers("OR")
PivotTable1.ActiveView.ColumnAxis("State").FilterMembers = Array(tmpMemberCol, tmpMemberRow)