XlPivotFilterType XlPivotFilterType XlPivotFilterType Enum

Definition

The type of filter applied.

public enum class XlPivotFilterType
public enum XlPivotFilterType
Public Enum XlPivotFilterType
Inheritance
XlPivotFilterTypeXlPivotFilterTypeXlPivotFilterType

Fields

xlAfter xlAfter xlAfter 33

Filters for all dates after a specified date

xlAfterOrEqualTo xlAfterOrEqualTo xlAfterOrEqualTo 34

Filters for all dates on or after a specified date

xlAllDatesInPeriodApril xlAllDatesInPeriodApril xlAllDatesInPeriodApril 60

Filters for all dates in April

xlAllDatesInPeriodAugust xlAllDatesInPeriodAugust xlAllDatesInPeriodAugust 64

Filters for all dates in August

xlAllDatesInPeriodDecember xlAllDatesInPeriodDecember xlAllDatesInPeriodDecember 68

Filters for all dates in December

xlAllDatesInPeriodFebruary xlAllDatesInPeriodFebruary xlAllDatesInPeriodFebruary 58

Filters for all dates in February

xlAllDatesInPeriodJanuary xlAllDatesInPeriodJanuary xlAllDatesInPeriodJanuary 57

Filters for all dates in January

xlAllDatesInPeriodJuly xlAllDatesInPeriodJuly xlAllDatesInPeriodJuly 63

Filters for all dates in July

xlAllDatesInPeriodJune xlAllDatesInPeriodJune xlAllDatesInPeriodJune 62

Filters for all dates in June

xlAllDatesInPeriodMarch xlAllDatesInPeriodMarch xlAllDatesInPeriodMarch 59

Filters for all dates in March

xlAllDatesInPeriodMay xlAllDatesInPeriodMay xlAllDatesInPeriodMay 61

Filters for all dates in May

xlAllDatesInPeriodNovember xlAllDatesInPeriodNovember xlAllDatesInPeriodNovember 67

Filters for all dates in November

xlAllDatesInPeriodOctober xlAllDatesInPeriodOctober xlAllDatesInPeriodOctober 66

Filters for all dates in October

xlAllDatesInPeriodQuarter1 xlAllDatesInPeriodQuarter1 xlAllDatesInPeriodQuarter1 53

Filters for all dates in Quarter1

xlAllDatesInPeriodQuarter2 xlAllDatesInPeriodQuarter2 xlAllDatesInPeriodQuarter2 54

Filters for all dates in Quarter2

xlAllDatesInPeriodQuarter3 xlAllDatesInPeriodQuarter3 xlAllDatesInPeriodQuarter3 55

Filters for all dates in Quarter3

xlAllDatesInPeriodQuarter4 xlAllDatesInPeriodQuarter4 xlAllDatesInPeriodQuarter4 56

Filters for all dates in Quarter 4

xlAllDatesInPeriodSeptember xlAllDatesInPeriodSeptember xlAllDatesInPeriodSeptember 65

Filters for all dates in September

xlBefore xlBefore xlBefore 31

Filters for all dates before a specified date

xlBeforeOrEqualTo xlBeforeOrEqualTo xlBeforeOrEqualTo 32

Filters for all dates on or before a specified date

xlBottomCount xlBottomCount xlBottomCount 2

Filters for the specified number of values from the bottom of a list

xlBottomPercent xlBottomPercent xlBottomPercent 4

Filters for the specified percentage of values from the bottom of a list

xlBottomSum xlBottomSum xlBottomSum 6

Sum of the values from the bottom of the list

xlCaptionBeginsWith xlCaptionBeginsWith xlCaptionBeginsWith 17

Filters for all captions beginning with the specified string

xlCaptionContains xlCaptionContains xlCaptionContains 21

Filters for all captions that contain the specified string

xlCaptionDoesNotBeginWith xlCaptionDoesNotBeginWith xlCaptionDoesNotBeginWith 18

Filters for all captions that do not begin with the specified string

xlCaptionDoesNotContain xlCaptionDoesNotContain xlCaptionDoesNotContain 22

Filters for all captions that do not contain the specified string

xlCaptionDoesNotEndWith xlCaptionDoesNotEndWith xlCaptionDoesNotEndWith 20

Filters for all captions that do not end with the specified string

xlCaptionDoesNotEqual xlCaptionDoesNotEqual xlCaptionDoesNotEqual 16

Filters for all captions that do not match the specified string

xlCaptionEndsWith xlCaptionEndsWith xlCaptionEndsWith 19

Filters for all captions that end with the specified string

xlCaptionEquals xlCaptionEquals xlCaptionEquals 15

Filters for all captions that match the specified string

xlCaptionIsBetween xlCaptionIsBetween xlCaptionIsBetween 27

Filters for all captions that are between a specified range of values

xlCaptionIsGreaterThan xlCaptionIsGreaterThan xlCaptionIsGreaterThan 23

Filters for all captions that are greater than the specified value

xlCaptionIsGreaterThanOrEqualTo xlCaptionIsGreaterThanOrEqualTo xlCaptionIsGreaterThanOrEqualTo 24

Filters for all captions that are greater than or match the specified value

xlCaptionIsLessThan xlCaptionIsLessThan xlCaptionIsLessThan 25

Filters for all captions that are less than the specified value

xlCaptionIsLessThanOrEqualTo xlCaptionIsLessThanOrEqualTo xlCaptionIsLessThanOrEqualTo 26

Filters for all captions that are less than or match the specified value

xlCaptionIsNotBetween xlCaptionIsNotBetween xlCaptionIsNotBetween 28

Filters for all captions that are not between a specified range of values

xlDateBetween xlDateBetween xlDateBetween 35

Filters for all dates that are between a specified range of dates

xlDateLastMonth xlDateLastMonth xlDateLastMonth 45

Filters for all dates that apply to the previous month

xlDateLastQuarter xlDateLastQuarter xlDateLastQuarter 48

Filters for all dates that apply to the previous quarter

xlDateLastWeek xlDateLastWeek xlDateLastWeek 42

Filters for all dates that apply to the previous week

xlDateLastYear xlDateLastYear xlDateLastYear 51

Filters for all dates that apply to the previous year

xlDateNextMonth xlDateNextMonth xlDateNextMonth 43

Filters for all dates that apply to the next month

xlDateNextQuarter xlDateNextQuarter xlDateNextQuarter 46

Filters for all dates that apply to the next quarter

xlDateNextWeek xlDateNextWeek xlDateNextWeek 40

Filters for all dates that apply to the next week

xlDateNextYear xlDateNextYear xlDateNextYear 49

Filters for all dates that apply to the next year

xlDateNotBetween xlDateNotBetween xlDateNotBetween 36
xlDateThisMonth xlDateThisMonth xlDateThisMonth 44

Filters for all dates that apply to the current month

xlDateThisQuarter xlDateThisQuarter xlDateThisQuarter 47

Filters for all dates that apply to the current quarter

xlDateThisWeek xlDateThisWeek xlDateThisWeek 41

Filters for all dates that apply to the current week

xlDateThisYear xlDateThisYear xlDateThisYear 50

Filters for all dates that apply to the current year

xlDateToday xlDateToday xlDateToday 38

Filters for all dates that apply to the current date

xlDateTomorrow xlDateTomorrow xlDateTomorrow 37

Filters for all dates that apply to the next day

xlDateYesterday xlDateYesterday xlDateYesterday 39

Filters for all dates that apply to the previous day

xlNotSpecificDate xlNotSpecificDate xlNotSpecificDate 30

Filters for all dates that do not match a specified date

xlSpecificDate xlSpecificDate xlSpecificDate 29

Filters for all dates that match a specified date

xlTopCount xlTopCount xlTopCount 1

Filters for the specified number of values from the top of a list

xlTopPercent xlTopPercent xlTopPercent 3

Filters for the specified percentage of values from a list

xlTopSum xlTopSum xlTopSum 5

Sum of the values from the top of the list

xlValueDoesNotEqual xlValueDoesNotEqual xlValueDoesNotEqual 8

Filters for all values that do not match the specified value

xlValueEquals xlValueEquals xlValueEquals 7

Filters for all values that match the specified value

xlValueIsBetween xlValueIsBetween xlValueIsBetween 13

Filters for all values that are between a specified range of values

xlValueIsGreaterThan xlValueIsGreaterThan xlValueIsGreaterThan 9

Filters for all values that are greater than the specified value

xlValueIsGreaterThanOrEqualTo xlValueIsGreaterThanOrEqualTo xlValueIsGreaterThanOrEqualTo 10

Filters for all values that are greater than or match the specified value

xlValueIsLessThan xlValueIsLessThan xlValueIsLessThan 11

Filters for all values that are less than the specified value

xlValueIsLessThanOrEqualTo xlValueIsLessThanOrEqualTo xlValueIsLessThanOrEqualTo 12

Filters for all values that are less than or match the specified value

xlValueIsNotBetween xlValueIsNotBetween xlValueIsNotBetween 14

Filters for all values that are not between a specified range of values

xlYearToDate xlYearToDate xlYearToDate 52

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

Applies to