XlPivotFilterType Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

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

52

Filters for all values that are within one year of a specified date

Show: