Edit

Share via

PivotFilter.IsMemberPropertyFilter property (Excel)

  • Article

Specifies whether the label filter is based on the PivotItem captions of a member property of the field or on the PivotItem captions of the PivotField itself. Read-only Boolean.

Syntax

expression.IsMemberPropertyFilter

expression A variable that represents a PivotFilter object.

Remarks

The default value of this property is False.

Returns True if the label filter is based on PivotItem captions of a member property of the PivotField, or returns False if the filter is based on the PivotItem captions of the PivotField. This property is valid only for Label filters and only for OLAP PivotFields that have at least one member property.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.