Enum PivotFilterType

PivotFilterType enumeration

Represents PivotTable Filter type.

public enum PivotFilterType

Values

NameValueDescription
CaptionBeginsWith0Indicates the “begins with” filter for field captions.
CaptionBetween1Indicates the “is between” filter for field captions.
CaptionContains2Indicates the “contains” filter for field captions.
CaptionEndsWith3Indicates the “ends with” filter for field captions.
CaptionEqual4Indicates the “equal” filter for field captions.
CaptionGreaterThan5Indicates the “is greater than” filter for field captions.
CaptionGreaterThanOrEqual6Indicates the “is greater than or equal to” filter for field captions.
CaptionLessThan7Indicates the “is less than” filter for field captions.
CaptionLessThanOrEqual8Indicates the “is less than or equal to” filter for field captions.
CaptionNotBeginsWith9Indicates the “does not begin with” filter for field captions.
CaptionNotBetween10Indicates the “is not between” filter for field captions.
CaptionNotContains11Indicates the “does not contain” filter for field captions.
CaptionNotEndsWith12Indicates the “does not end with” filter for field captions.
CaptionNotEqual13Indicates the “not equal” filter for field captions.
Count14Indicates the “count” filter.
DateBetween15Indicates the “between” filter for date values.
DateEqual16Indicates the “equals” filter for date values.
DateNewerThan17Indicates the “newer than” filter for date values.
DateNewerThanOrEqual18Indicates the “newer than or equal to” filter for date values.
DateNotBetween19Indicates the “not between” filter for date values.
DateNotEqual20Indicates the “does not equal” filter for date values.
DateOlderThan21Indicates the “older than” filter for date values.
DateOlderThanOrEqual22Indicates the “older than or equal to” filter for date values.
LastMonth23Indicates the “last month” filter for date values.
LastQuarter24Indicates the “last quarter” filter for date values.
LastWeek25Indicates the “last week” filter for date values.
LastYear26Indicates the “last year” filter for date values.
M127Indicates the “January” filter for date values.
M228Indicates the “February” filter for date values.
M329Indicates the “March” filter for date values.
M430Indicates the “April” filter for date values.
M531Indicates the “May” filter for date values.
M632Indicates the “June” filter for date values.
M733Indicates the “July” filter for date values.
M834Indicates the “August” filter for date values.
M935Indicates the “September” filter for date values.
M1036Indicates the “October” filter for date values.
M1137Indicates the “November” filter for date values.
M1238Indicates the “December” filter for date values.
NextMonth39Indicates the “next month” filter for date values.
NextQuarter40Indicates the “next quarter” for date values.
NextWeek41Indicates the “next week” for date values.
NextYear42Indicates the “next year” filter for date values.
Percent43Indicates the “percent” filter for numeric values.
Q144Indicates the “first quarter” filter for date values.
Q245Indicates the “second quarter” filter for date values.
Q346Indicates the “third quarter” filter for date values.
Q447Indicates the “fourth quarter” filter for date values.
Sum48Indicates the “sum” filter for numeric values.
ThisMonth49Indicates the “this month” filter for date values.
ThisQuarter50Indicates the “this quarter” filter for date values.
ThisWeek51Indicates the “this week” filter for date values.
ThisYear52Indicate the “this year” filter for date values.
Today53Indicates the “today” filter for date values.
Tomorrow54Indicates the “tomorrow” filter for date values.
Unknown55Indicates the PivotTable filter is unknown to the application.
ValueBetween56Indicates the “Value between” filter for text and numeric values.
ValueEqual57Indicates the “value equal” filter for text and numeric values.
ValueGreaterThan58Indicates the “value greater than” filter for text and numeric values.
ValueGreaterThanOrEqual59Indicates the “value greater than or equal to” filter for text and numeric values.
ValueLessThan60Indicates the “value less than” filter for text and numeric values.
ValueLessThanOrEqual61Indicates the “value less than or equal to” filter for text and numeric values.
ValueNotBetween62Indicates the “value not between” filter for text and numeric values.
ValueNotEqual63Indicates the “value not equal” filter for text and numeric values.
YearToDate64Indicates the “year-to-date” filter for date values.
Yesterday65Indicates the “yesterday” filter for date values.

See Also