Enum PivotFilterType
Pivot filter type
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public enum PivotFilterTypeFields
| Name | 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 "dateBetween" filter. |
| DateEqual | Indicates the "dateEqual" filter. |
| dateNewerThan | Indicates the "dateNewerThan" filter. |
| DateNewerThanOrEqual | Indicates the "dateNewerThanOrEqual" filter. |
| DateNotBetween | Indicates the "dateNotBetween" filter. |
| DateNotEqual | Indicates the "dateNotEqual" filter. |
| DateOlderThan | Indicates the "dateOlderThan" filter. |
| DateOlderThanOrEqual | Indicates the "dateOlderThanOrEqual" filter. |
| LastMonth | Indicates the "lastMonth" filter. |
| LastQuarter | Indicates the "lastQuarter" filter. |
| LastWeek | Indicates the "lastWeek" filter. |
| LastYear | Indicates the "lastYear" filter. |
| M1 | Indicates the "M1" filter. |
| M10 | Indicates the "M10" filter. |
| M11 | Indicates the "M11" filter. |
| M12 | Indicates the "M12" filter. |
| M2 | Indicates the "M2" filter. |
| M3 | Indicates the "M3" filter. |
| M4 | Indicates the "M4" filter. |
| M5 | Indicates the "M5" filter. |
| M6 | Indicates the "M6" filter. |
| M7 | Indicates the "M7" filter. |
| M8 | Indicates the "M8" filter. |
| M9 | Indicates the "M9" filter. |
| NextMonth | Indicates the "nextMonth" filter. |
| NextQuarter | Indicates the "nextQuarter" filter. |
| NextYear | Indicates the "nextYear" filter. |
| NexWeek | Indicates the "nextWeek" filter. |
| Percent | Indicates the "percent" filter. |
| Q1 | Indicates the "Q1" filter. |
| Q2 | Indicates the "Q2" filter. |
| Q3 | Indicates the "Q3" filter. |
| Q4 | Indicates the "Q4" filter. |
| Sum | Indicates the "sum" filter. |
| ThisMonth | Indicates the "thisMonth" filter. |
| ThisQuarter | Indicates the "thisQuarter" filter. |
| ThisWeek | Indicates the "thisWeek" filter. |
| ThisYear | Indicates the "thisYear" filter. |
| Today | Indicates the "today" filter. |
| Tomorrow | Indicates the "tomorrow" filter. |
| Unknown | Indicates the "unknown" filter. |
| 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 "yearToDate" filter. |
| Yesterday | Indicates the "yesterday" filter. |