PivotFilterType Enum
Contents
[
Hide
]PivotFilterType Enum
Represents the filter type of the pivot table.
type PivotFilterType int32
Fields
| Field | Description |
|---|---|
| CaptionBeginsWith | Indicates the “begins with” filter for field captions. |
| CaptionBetween | Indicates the “is between” filter for field captions. |
| CaptionContains | Indicates the “contains” filter for field captions. |
| CaptionEndsWith | Indicates the “ends with” filter for field captions. |
| CaptionEqual | Indicates the “equal” filter for field captions. |
| CaptionGreaterThan | Indicates the “is greater than” filter for field captions. |
| CaptionGreaterThanOrEqual | Indicates the “is greater than or equal to” filter for field captions. |
| CaptionLessThan | Indicates the “is less than” filter for field captions. |
| CaptionLessThanOrEqual | Indicates the “is less than or equal to” filter for field captions. |
| CaptionNotBeginsWith | Indicates the “does not begin with” filter for field captions. |
| CaptionNotBetween | Indicates the “is not between” filter for field captions. |
| CaptionNotContains | Indicates the “does not contain” filter for field captions. |
| CaptionNotEndsWith | Indicates the “does not end with” filter for field captions. |
| CaptionNotEqual | Indicates the “not equal” filter for field captions. |
| Count | Indicates the “count” filter. |
| DateBetween | Indicates the “between” filter for date values. |
| DateEqual | Indicates the “equals” filter for date values. |
| DateAfter | Indicates the “after” filter for date values. |
| DateAfterOrEqual | Indicates the “after or equal to” filter for date values. |
| DateNotBetween | Indicates the “not between” filter for date values. |
| DateNotEqual | Indicates the “does not equal” filter for date values. |
| DateBefore | Indicates the “before” filter for date values. |
| DateBeforeOrEqual | Indicates the “before or equal to” filter for date values. |
| LastMonth | Indicates the “last month” filter for date values. |
| LastQuarter | Indicates the “last quarter” filter for date values. |
| LastWeek | Indicates the “last week” filter for date values. |
| LastYear | Indicates the “last year” filter for date values. |
| January | Indicates the “January” filter for date values. |
| February | Indicates the “February” filter for date values. |
| March | Indicates the “March” filter for date values. |
| April | Indicates the “April” filter for date values. |
| May | Indicates the “May” filter for date values. |
| June | Indicates the “June” filter for date values. |
| July | Indicates the “July” filter for date values. |
| August | Indicates the “August” filter for date values. |
| September | Indicates the “September” filter for date values. |
| October | Indicates the “October” filter for date values. |
| November | Indicates the “November” filter for date values. |
| December | Indicates the “December” filter for date values. |
| NextMonth | Indicates the “next month” filter for date values. |
| NextQuarter | Indicates the “next quarter” for date values. |
| NextWeek | Indicates the “next week” for date values. |
| NextYear | Indicates the “next year” filter for date values. |
| Percent | Indicates the “percent” filter for numeric values. |
| Quarter1 | Indicates the “first quarter” filter for date values. |
| Quarter2 | Indicates the “second quarter” filter for date values. |
| Quarter3 | Indicates the “third quarter” filter for date values. |
| Quarter4 | Indicates the “fourth quarter” filter for date values. |
| Sum | Indicates the “sum” filter for numeric values. |
| ThisMonth | Indicates the “this month” filter for date values. |
| ThisQuarter | Indicates the “this quarter” filter for date values. |
| ThisWeek | Indicates the “this week” filter for date values. |
| ThisYear | Indicate the “this year” filter for date values. |
| Today | Indicates the “today” filter for date values. |
| Tomorrow | Indicates the “tomorrow” filter for date values. |
| Unknown | Indicates the PivotTable filter is unknown to the application. |
| ValueBetween | Indicates the “Value between” filter for text and numeric values. |
| ValueEqual | Indicates the “value equal” filter for text and numeric values. |
| ValueGreaterThan | Indicates the “value greater than” filter for text and numeric values. |
| ValueGreaterThanOrEqual | Indicates the “value greater than or equal to” filter for text and numeric values. |
| ValueLessThan | Indicates the “value less than” filter for text and numeric values. |
| ValueLessThanOrEqual | Indicates the “value less than or equal to” filter for text and numeric values. |
| ValueNotBetween | Indicates the “value not between” filter for text and numeric values. |
| ValueNotEqual | Indicates the “value not equal” filter for text and numeric values. |
| YearToDate | Indicates the “year-to-date” filter for date values. |
| Yesterday | Indicates the “yesterday” filter for date values. |
| None | No filter. |