XlPivotFilterType Enumeration
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 |