Collapse the table of content
Expand the table of content
Expand Minimize

XlPivotFilterType Enumeration (Excel)

The type of filter applied.

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

Show:
© 2015 Microsoft