XlPivotFilterType Enumeration
| Excel Developer Reference |
The type of filter applied.
Version Information
Version Added: Excel 2007
| 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 | 53 | Filters for all dates in January |
| xlAllDatesInPeriodFebruary | 54 | Filters for all dates in February |
| xlAllDatesInPeriodMarch | 55 | Filters for all dates in March |
| xlAllDatesInPeriodApril | 56 | Filters for all dates in April |
| xlAllDatesInPeriodMay | 57 | Filters for all dates in May |
| xlAllDatesInPeriodJune | 58 | Filters for all dates in June |
| xlAllDatesInPeriodJuly | 59 | Filters for all dates in July |
| xlAllDatesInPeriodAugust | 60 | Filters for all dates in August |
| xlAllDatesInPeriodSeptember | 61 | Filters for all dates in September |
| xlAllDatesInPeriodOctober | 62 | Filters for all dates in October |
| xlAllDatesInPeriodNovember | 63 | Filters for all dates in November |
| xlAllDatesInPeriodDecember | 64 | Filters for all dates in December |
| xlAllDatesInPeriodQuarter1 | 49 | Filters for all dates in Quarter1 |
| xlAllDatesInPeriodQuarter2 | 50 | Filters for all dates in Quarter2 |
| xlAllDatesInPeriodQuarter3 | 51 | Filters for all dates in Quarter3 |
| xlAllDatesInPeriodQuarter4 | 52 | 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 do not begin with the specified string |
| xlCaptionDoesNotContain | 22 | Filters for all captions that do not contain the specified string |
| xlCaptionDoesNotEndWith | 20 | Filters for all captions that do not end with the specified string |
| xlCaptionDoesNotEqual | 16 | Filters for all captions that do not 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 | 32 | Filters for all dates that are between a specified range of dates |
| xlDateLastMonth | 41 | Filters for all dates that apply to the previous month |
| xlDateLastQuarter | 44 | Filters for all dates that apply to the previous quarter |
| xlDateLastWeek | 38 | Filters for all dates that apply to the previous week |
| xlDateLastYear | 47 | Filters for all dates that apply to the previous year |
| xlDateNextMonth | 39 | Filters for all dates that apply to the next month |
| xlDateNextQuarter | 42 | Filters for all dates that apply to the next quarter |
| xlDateNextWeek | 36 | Filters for all dates that apply to the next week |
| xlDateNextYear | 45 | Filters for all dates that apply to the next year |
| xlDateThisMonth | 40 | Filters for all dates that apply to the current month |
| xlDateThisQuarter | 43 | Filters for all dates that apply to the current quarter |
| xlDateThisWeek | 37 | Filters for all dates that apply to the current week |
| xlDateThisYear | 46 | Filters for all dates that apply to the current year |
| xlDateToday | 34 | Filters for all dates that apply to the current date |
| xlDateTomorrow | 33 | Filters for all dates that apply to the next day |
| xlDateYesterday | 35 | Filters for all dates that apply to the previous day |
| xlNotSpecificDate | 30 | Filters for all dates that do not 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 do not 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 | 48 | Filters for all values that are within one year of a specified date |