Export (0) Print
Expand All

PivotFilter.FilterType Property

Office 2007
Specifies the type of filter to be applied. Read-only xlPivotFilterType.

Version Information
 Version Added:  Excel 2007

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.

xlPivotFilterTypeDataFieldDataCubeField (OLAP)Value1Value2
xlTopCountRequiredRequiredRequiredUnavailable
xlBottomCountRequiredRequiredRequiredUnavailable
xlTopPercentRequiredRequiredRequiredUnavailable
xlBottomPercentRequiredRequiredRequiredUnavailable
xlTopSumRequiredRequiredRequiredUnavailable
xlBottomSumRequiredRequiredRequiredUnavailable
xlCaptionEqualsUnavailableUnavailableRequiredUnavailable
xlCaptionDoesNotEqualUnavailableUnavailableRequiredUnavailable
xlCaptionIsGreaterThanUnavailableUnavailableRequiredUnavailable
xlCaptionIsGreaterThanOrEqualToUnavailableUnavailableRequiredUnavailable
xlCaptionIsLessThanUnavailableUnavailableRequiredUnavailable
xlCaptionIsLessThanOrEqualToUnavailableUnavailableRequiredUnavailable
xlCaptionBeginsWithUnavailableUnavailableRequiredUnavailable
xlCaptionDoesNotBeginWithUnavailableUnavailableRequiredUnavailable
xlCaptionEndsWithUnavailableUnavailableRequiredUnavailable
xlCaptionDoesNotEndWithUnavailableUnavailableRequiredUnavailable
xlCaptionContainsUnavailableUnavailableRequiredUnavailable
xlCaptionDoesNotContainUnavailableUnavailableRequiredUnavailable
xlCaptionIsBetweenUnavailableUnavailableRequiredRequired
xlCaptionIsNotBetweenUnavailableUnavailableRequiredRequired
xlValueEqualsRequiredRequiredRequiredUnavailable
xlValueDoesNotEqualRequiredRequiredRequiredUnavailable
xlValueIsGreaterThanRequiredRequiredRequiredUnavailable
xlValueIsGreaterThanOrEqualToRequiredRequiredRequiredUnavailable
xlValueIsLessThanRequiredRequiredRequiredUnavailable
xlValueIsLessThanOrEqualToRequiredRequiredRequiredUnavailable
xlValueIsBetweenRequiredRequiredRequiredRequired
xlValueIsNotBetweenRequiredRequiredRequiredRequired
xlSpecificDateUnavailableUnavailableRequiredUnavailable
xlNotSpecificDateUnavailableUnavailableRequiredUnavailable
xlBeforeUnavailableUnavailableRequiredUnavailable
xlBeforeOrEqualToUnavailableUnavailableRequiredUnavailable
xlAfterUnavailableUnavailableRequiredUnavailable
xlAfterOrEqualToUnavailableUnavailableRequiredUnavailable
xlBetweenUnavailableUnavailableRequiredUnavailable
xlNotBetweenUnavailableUnavailableRequiredUnavailable
xlFilterTodayUnavailableUnavailableUnavailableUnavailable
xlFilterYesterdayUnavailableUnavailableUnavailableUnavailable
xlFilterTomorrowUnavailableUnavailableUnavailableUnavailable
xlFilterThisWeekUnavailableUnavailableUnavailableUnavailable
xlFilterLastWeekUnavailableUnavailableUnavailableUnavailable
xlFilterNextWeekUnavailableUnavailableUnavailableUnavailable
xlFilterThisMonthUnavailableUnavailableUnavailableUnavailable
xlFilterLastMonthUnavailableUnavailableUnavailableUnavailable
xlFilterNextMonthUnavailableUnavailableUnavailableUnavailable
xlFilterThisQuarterUnavailableUnavailableUnavailableUnavailable
xlFilterLastQuarterUnavailableUnavailableUnavailableUnavailable
xlFilterNextQuarterUnavailableUnavailableUnavailableUnavailable
xlFilterThisYearUnavailableUnavailableUnavailableUnavailable
xlFilterLastYearUnavailableUnavailableUnavailableUnavailable
xlFilterNextYearUnavailableUnavailableUnavailableUnavailable
xlFilterYearToDateUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodQuarter1UnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodQuarter2UnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodQuarter3UnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodQuarter4UnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodJanuaryUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodFebruaryUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodMarchUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodAprilUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodMayUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodJuneUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodJulyUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodAugustUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodSeptemberUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodOctoberUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodNovemberUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodDecemberUnavailableUnavailableUnavailableUnavailable



Community Additions

ADD
Show:
© 2014 Microsoft