PivotFilterType

PivotFilterType enumeration

Represents PivotTable Filter type.

public enum PivotFilterType

Values

Name Value Description
CaptionBeginsWith 0 Indicates the “begins with” filter for field captions.
CaptionBetween 1 Indicates the “is between” filter for field captions.
CaptionContains 2 Indicates the “contains” filter for field captions.
CaptionEndsWith 3 Indicates the “ends with” filter for field captions.
CaptionEqual 4 Indicates the “equal” filter for field captions.
CaptionGreaterThan 5 Indicates the “is greater than” filter for field captions.
CaptionGreaterThanOrEqual 6 Indicates the “is greater than or equal to” filter for field captions.
CaptionLessThan 7 Indicates the “is less than” filter for field captions.
CaptionLessThanOrEqual 8 Indicates the “is less than or equal to” filter for field captions.
CaptionNotBeginsWith 9 Indicates the “does not begin with” filter for field captions.
CaptionNotBetween 10 Indicates the “is not between” filter for field captions.
CaptionNotContains 11 Indicates the “does not contain” filter for field captions.
CaptionNotEndsWith 12 Indicates the “does not end with” filter for field captions.
CaptionNotEqual 13 Indicates the “not equal” filter for field captions.
Count 14 Indicates the “count” filter.
DateBetween 15 Indicates the “between” filter for date values.
DateEqual 16 Indicates the “equals” filter for date values.
DateNewerThan 17 Indicates the “newer than” filter for date values.
DateNewerThanOrEqual 18 Indicates the “newer than or equal to” filter for date values.
DateNotBetween 19 Indicates the “not between” filter for date values.
DateNotEqual 20 Indicates the “does not equal” filter for date values.
DateOlderThan 21 Indicates the “older than” filter for date values.
DateOlderThanOrEqual 22 Indicates the “older than or equal to” filter for date values.
LastMonth 23 Indicates the “last month” filter for date values.
LastQuarter 24 Indicates the “last quarter” filter for date values.
LastWeek 25 Indicates the “last week” filter for date values.
LastYear 26 Indicates the “last year” filter for date values.
M1 27 Indicates the “January” filter for date values.
M2 28 Indicates the “February” filter for date values.
M3 29 Indicates the “March” filter for date values.
M4 30 Indicates the “April” filter for date values.
M5 31 Indicates the “May” filter for date values.
M6 32 Indicates the “June” filter for date values.
M7 33 Indicates the “July” filter for date values.
M8 34 Indicates the “August” filter for date values.
M9 35 Indicates the “September” filter for date values.
M10 36 Indicates the “October” filter for date values.
M11 37 Indicates the “November” filter for date values.
M12 38 Indicates the “December” filter for date values.
NextMonth 39 Indicates the “next month” filter for date values.
NextQuarter 40 Indicates the “next quarter” for date values.
NextWeek 41 Indicates the “next week” for date values.
NextYear 42 Indicates the “next year” filter for date values.
Percent 43 Indicates the “percent” filter for numeric values.
Q1 44 Indicates the “first quarter” filter for date values.
Q2 45 Indicates the “second quarter” filter for date values.
Q3 46 Indicates the “third quarter” filter for date values.
Q4 47 Indicates the “fourth quarter” filter for date values.
Sum 48 Indicates the “sum” filter for numeric values.
ThisMonth 49 Indicates the “this month” filter for date values.
ThisQuarter 50 Indicates the “this quarter” filter for date values.
ThisWeek 51 Indicates the “this week” filter for date values.
ThisYear 52 Indicate the “this year” filter for date values.
Today 53 Indicates the “today” filter for date values.
Tomorrow 54 Indicates the “tomorrow” filter for date values.
Unknown 55 Indicates the PivotTable filter is unknown to the application.
ValueBetween 56 Indicates the “Value between” filter for text and numeric values.
ValueEqual 57 Indicates the “value equal” filter for text and numeric values.
ValueGreaterThan 58 Indicates the “value greater than” filter for text and numeric values.
ValueGreaterThanOrEqual 59 Indicates the “value greater than or equal to” filter for text and numeric values.
ValueLessThan 60 Indicates the “value less than” filter for text and numeric values.
ValueLessThanOrEqual 61 Indicates the “value less than or equal to” filter for text and numeric values.
ValueNotBetween 62 Indicates the “value not between” filter for text and numeric values.
ValueNotEqual 63 Indicates the “value not equal” filter for text and numeric values.
YearToDate 64 Indicates the “year-to-date” filter for date values.
Yesterday 65 Indicates the “yesterday” filter for date values.

See Also

PivotFilterCollection PivotFormatCondition