Enum PivotFilterType
Pivot filter type
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public enum PivotFilterType
Fields
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. |