PivotFilter.FilterType property (Excel)

Specifies the type of filter to be applied. Read-only XlPivotFilterType.

Syntax

expression.FilterType

expression A variable that represents a PivotFilter object.

Remarks

The following table shows the new filter types, the arguments that must be supplied, and the arguments that cannot be supplied (Unavailable) for each filter type.

XlPivotFilterType	DataField	DataCubeField (OLAP)	Value1	Value2
xlTopCount	Required	Required	Required	Unavailable
xlBottomCount	Required	Required	Required	Unavailable
xlTopPercent	Required	Required	Required	Unavailable
xlBottomPercent	Required	Required	Required	Unavailable
xlTopSum	Required	Required	Required	Unavailable
xlBottomSum	Required	Required	Required	Unavailable
xlCaptionEquals	Unavailable	Unavailable	Required	Unavailable
xlCaptionDoesNotEqual	Unavailable	Unavailable	Required	Unavailable
xlCaptionIsGreaterThan	Unavailable	Unavailable	Required	Unavailable
xlCaptionIsGreaterThanOrEqualTo	Unavailable	Unavailable	Required	Unavailable
xlCaptionIsLessThan	Unavailable	Unavailable	Required	Unavailable
xlCaptionIsLessThanOrEqualTo	Unavailable	Unavailable	Required	Unavailable
xlCaptionBeginsWith	Unavailable	Unavailable	Required	Unavailable
xlCaptionDoesNotBeginWith	Unavailable	Unavailable	Required	Unavailable
xlCaptionEndsWith	Unavailable	Unavailable	Required	Unavailable
xlCaptionDoesNotEndWith	Unavailable	Unavailable	Required	Unavailable
xlCaptionContains	Unavailable	Unavailable	Required	Unavailable
xlCaptionDoesNotContain	Unavailable	Unavailable	Required	Unavailable
xlCaptionIsBetween	Unavailable	Unavailable	Required	Required
xlCaptionIsNotBetween	Unavailable	Unavailable	Required	Required
xlValueEquals	Required	Required	Required	Unavailable
xlValueDoesNotEqual	Required	Required	Required	Unavailable
xlValueIsGreaterThan	Required	Required	Required	Unavailable
xlValueIsGreaterThanOrEqualTo	Required	Required	Required	Unavailable
xlValueIsLessThan	Required	Required	Required	Unavailable
xlValueIsLessThanOrEqualTo	Required	Required	Required	Unavailable
xlValueIsBetween	Required	Required	Required	Required
xlValueIsNotBetween	Required	Required	Required	Required
xlSpecificDate	Unavailable	Unavailable	Required	Unavailable
xlNotSpecificDate	Unavailable	Unavailable	Required	Unavailable
xlBefore	Unavailable	Unavailable	Required	Unavailable
xlBeforeOrEqualTo	Unavailable	Unavailable	Required	Unavailable
xlAfter	Unavailable	Unavailable	Required	Unavailable
xlAfterOrEqualTo	Unavailable	Unavailable	Required	Unavailable
xlBetween	Unavailable	Unavailable	Required	Unavailable
xlNotBetween	Unavailable	Unavailable	Required	Unavailable
xlFilterToday	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterYesterday	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterTomorrow	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterThisWeek	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterLastWeek	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterNextWeek	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterThisMonth	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterLastMonth	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterNextMonth	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterThisQuarter	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterLastQuarter	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterNextQuarter	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterThisYear	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterLastYear	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterNextYear	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterYearToDate	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodQuarter1	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodQuarter2	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodQuarter3	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodQuarter4	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodJanuary	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodFebruary	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodMarch	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodApril	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodMay	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodJune	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodJuly	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodAugust	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodSeptember	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodOctober	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodNovember	Unavailable	Unavailable	Unavailable	Unavailable
xlFilterAllDatesInPeriodDecember	Unavailable	Unavailable	Unavailable	Unavailable

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.