Edit

XlPivotFilterType Enum

  • Reference

Definition

Namespace:
Microsoft.Office.Interop.Excel
Assembly:
Microsoft.Office.Interop.Excel.dll

The type of filter applied.

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

Fields

xlAfter 33

Filters for all dates after a specified date
xlAfterOrEqualTo 34

Filters for all dates on or after a specified date
xlAllDatesInPeriodApril 60

Filters for all dates in April
xlAllDatesInPeriodAugust 64

Filters for all dates in August
xlAllDatesInPeriodDecember 68

Filters for all dates in December
xlAllDatesInPeriodFebruary 58

Filters for all dates in February
xlAllDatesInPeriodJanuary 57

Filters for all dates in January
xlAllDatesInPeriodJuly 63

Filters for all dates in July
xlAllDatesInPeriodJune 62

Filters for all dates in June
xlAllDatesInPeriodMarch 59

Filters for all dates in March
xlAllDatesInPeriodMay 61

Filters for all dates in May
xlAllDatesInPeriodNovember 67

Filters for all dates in November
xlAllDatesInPeriodOctober 66

Filters for all dates in October
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
xlAllDatesInPeriodSeptember 65

Filters for all dates in September
xlBefore 31

Filters for all dates before a specified date
xlBeforeOrEqualTo 32

Filters for all dates on or before a specified date
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
xlDateNotBetween 36
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

Applies to