PivotFilter Object Members

  • Article
Excel Developer Reference

A PivotFilter is applied to a PivotField object.

Methods

  Name Description
Bb256081.methods(en-us,office.12).gif Delete Deletes the filter and removes it from the filter collections of the PivotField and the PivotTable.

Properties

  Name Description
Bb256081.properties(en-us,office.12).gif Active Returns whether the specified PivotFilter is active. Read-only Boolean.
Bb256081.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Office Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.
Bb256081.properties(en-us,office.12).gif Creator Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
Bb256081.properties(en-us,office.12).gif DataCubeField This property is applicable only to OLAP PivotTables and provides the Value field (PivotField in the Values area) being filtered by for a value filter. Read/write CubeField.
Bb256081.properties(en-us,office.12).gif DataField This property is applicable only to non-OLAP PivotTables and provides the Value field (PivotField in the Values area) being filtered by for a value filter. Read/write PivotField.
Bb256081.properties(en-us,office.12).gif Description Provides an optional description for the PivotFilter object. Read-only String.
Bb256081.properties(en-us,office.12).gif FilterType Specifies the type of filter to be applied. Read-only xlPivotFilterType.
Bb256081.properties(en-us,office.12).gif IsMemberPropertyFilter 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.
Bb256081.properties(en-us,office.12).gif MemberPropertyField This property specifies the member property PivotField on which the label filter is based. Read/write PivotField.
Bb256081.properties(en-us,office.12).gif Name This property provides the option of naming filters for reference. You cannot rely on the index value for accurate reference because this value can change.
Bb256081.properties(en-us,office.12).gif Order Specifies the evaluation order of the filter among all Value filters applied to the entire PivotTable. Read/write Integer.
Bb256081.properties(en-us,office.12).gif Parent Returns the parent object for the specified PivotFilter object. Read-only.
Bb256081.properties(en-us,office.12).gif PivotField Specifies the PivotField to which the filter is applied. Read-only.
Bb256081.properties(en-us,office.12).gif Value1 This property is a user-supplied parameter to define a filter for a PivotField. Read/write Variant.
Bb256081.properties(en-us,office.12).gif Value2 This property is a user-supplied parameter to define a filter for a PivotField. Read/write Variant.