Edit

XlPivotFilterType enumeration (Excel)

  • Article

The type of filter applied.

Name Value Description
xlBefore 31 Filters for all dates before a specified date
xlBeforeOrEqualTo 32 Filters for all dates on or before a specified date
xlAfter 33 Filters for all dates after a specified date
xlAfterOrEqualTo 34 Filters for all dates on or after a specified date
xlAllDatesInPeriodJanuary 57 Filters for all dates in January
xlAllDatesInPeriodFebruary 58 Filters for all dates in February
xlAllDatesInPeriodMarch 59 Filters for all dates in March
xlAllDatesInPeriodApril 60 Filters for all dates in April
xlAllDatesInPeriodMay 61 Filters for all dates in May
xlAllDatesInPeriodJune 62 Filters for all dates in June
xlAllDatesInPeriodJuly 63 Filters for all dates in July
xlAllDatesInPeriodAugust 64 Filters for all dates in August
xlAllDatesInPeriodSeptember 65 Filters for all dates in September
xlAllDatesInPeriodOctober 66 Filters for all dates in October
xlAllDatesInPeriodNovember 67 Filters for all dates in November
xlAllDatesInPeriodDecember 68 Filters for all dates in December
xlAllDatesInPeriodQuarter1 53 Filters for all dates in Quarter1
xlAllDatesInPeriodQuarter2 54 Filters for all dates in Quarter2
xlAllDatesInPeriodQuarter3 55 Filters for all dates in Quarter3
xlAllDatesInPeriodQuarter4 56 Filters for all dates in Quarter 4
xlBottomCount 2 Filters for the specified number of values from the bottom of a list
xlBottomPercent 4 Filters for the specified percentage of values from the bottom of a list
xlBottomSum 6 Sum of the values from the bottom of the list
xlCaptionBeginsWith 17 Filters for all captions beginning with the specified string
xlCaptionContains 21 Filters for all captions that contain the specified string
xlCaptionDoesNotBeginWith 18 Filters for all captions that don't begin with the specified string
xlCaptionDoesNotContain 22 Filters for all captions that don't contain the specified string
xlCaptionDoesNotEndWith 20 Filters for all captions that don't end with the specified string
xlCaptionDoesNotEqual 16 Filters for all captions that don't match the specified string
xlCaptionEndsWith 19 Filters for all captions that end with the specified string
xlCaptionEquals 15 Filters for all captions that match the specified string
xlCaptionIsBetween 27 Filters for all captions that are between a specified range of values
xlCaptionIsGreaterThan 23 Filters for all captions that are greater than the specified value
xlCaptionIsGreaterThanOrEqualTo 24 Filters for all captions that are greater than or match the specified value
xlCaptionIsLessThan 25 Filters for all captions that are less than the specified value
xlCaptionIsLessThanOrEqualTo 26 Filters for all captions that are less than or match the specified value
xlCaptionIsNotBetween 28 Filters for all captions that are not between a specified range of values
xlDateBetween 35 Filters for all dates that are between a specified range of dates
xlDateLastMonth 45 Filters for all dates that apply to the previous month
xlDateLastQuarter 48 Filters for all dates that apply to the previous quarter
xlDateLastWeek 42 Filters for all dates that apply to the previous week
xlDateLastYear 51 Filters for all dates that apply to the previous year
xlDateNextMonth 43 Filters for all dates that apply to the next month
xlDateNextQuarter 46 Filters for all dates that apply to the next quarter
xlDateNextWeek 40 Filters for all dates that apply to the next week
xlDateNextYear 49 Filters for all dates that apply to the next year
xlDateThisMonth 44 Filters for all dates that apply to the current month
xlDateThisQuarter 47 Filters for all dates that apply to the current quarter
xlDateThisWeek 41 Filters for all dates that apply to the current week
xlDateThisYear 50 Filters for all dates that apply to the current year
xlDateToday 38 Filters for all dates that apply to the current date
xlDateTomorrow 37 Filters for all dates that apply to the next day
xlDateYesterday 39 Filters for all dates that apply to the previous day
xlNotSpecificDate 30 Filters for all dates that don't match a specified date
xlSpecificDate 29 Filters for all dates that match a specified date
xlTopCount 1 Filters for the specified number of values from the top of a list
xlTopPercent 3 Filters for the specified percentage of values from a list
xlTopSum 5 Sum of the values from the top of the list
xlValueDoesNotEqual 8 Filters for all values that don't match the specified value
xlValueEquals 7 Filters for all values that match the specified value
xlValueIsBetween 13 Filters for all values that are between a specified range of values
xlValueIsGreaterThan 9 Filters for all values that are greater than the specified value
xlValueIsGreaterThanOrEqualTo 10 Filters for all values that are greater than or match the specified value
xlValueIsLessThan 11 Filters for all values that are less than the specified value
xlValueIsLessThanOrEqualTo 12 Filters for all values that are less than or match the specified value
xlValueIsNotBetween 14 Filters for all values that are not between a specified range of values
xlYearToDate 52 Filters for all values that are within one year of a specified date

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.