Enum ePivotTableFilterType
Defines a pivot table filter type
Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll
Syntax
public enum ePivotTableFilterTypeFields
| Name | Description |
|---|---|
| CaptionBeginsWith | A caption filter - Begins With |
| CaptionBetween | A caption filter - Between |
| CaptionContains | A caption filter - Contains |
| CaptionEndsWith | A caption filter - Ends With |
| CaptionEqual | A caption filter - Equal |
| CaptionGreaterThan | A caption filter - Greater Than |
| CaptionGreaterThanOrEqual | A caption filter - Greater Than Or Equal |
| CaptionLessThan | A caption filter - Less Than |
| CaptionLessThanOrEqual | A caption filter - Less Than Or Equal |
| CaptionNotBeginsWith | A caption filter - Not Begins With |
| CaptionNotBetween | A caption filter - Not Between |
| CaptionNotContains | A caption filter - Not Contains |
| CaptionNotEndsWith | A caption filter - Not Ends With |
| CaptionNotEqual | A caption filter - Not Equal |
| Count | A top/bottom filter - Count |
| DateBetween | A date filter - Between |
| DateEqual | A date filter - Equal |
| DateNewerThan | A date filter - Newer Than |
| DateNewerThanOrEqual | A date filter - Newer Than Or Equal |
| DateNotBetween | A date filter - Not Between |
| DateNotEqual | A date filter - Not Equal |
| DateOlderThan | A date filter - Older Than |
| DateOlderThanOrEqual | A date filter - Older Than Or Equal |
| LastMonth | A date filter - Last Month |
| LastQuarter | A date filter - Last Quarter |
| LastWeek | A date filter - Last Week |
| LastYear | A date filter - Last Year |
| M1 | A date filter - Januari |
| M10 | A date filter - October |
| M11 | A date filter - November |
| M12 | A date filter - December |
| M2 | A date filter - Februari |
| M3 | A date filter - March |
| M4 | A date filter - April |
| M5 | A date filter - May |
| M6 | A date filter - June |
| M7 | A date filter - July |
| M8 | A date filter - August |
| M9 | A date filter - September |
| NextMonth | A date filter - Next Month |
| NextQuarter | A date filter - Next Quarter |
| NextWeek | A date filter - Next Week |
| NextYear | A date filter - Next Year |
| Percent | A top/bottom filter - Percent |
| Q1 | A date filter - The First Quarter |
| Q2 | A date filter - The Second Quarter |
| Q3 | A date filter - The Third Quarter |
| Q4 | A date filter - The Forth Quarter |
| Sum | A top/bottom filter - Sum |
| ThisMonth | A date filter - This Month |
| ThisQuarter | A date filter - This Quarter |
| ThisWeek | A date filter - This Week |
| ThisYear | A date filter - This Year |
| Today | A date filter - Today |
| Tomorrow | A date filter - Tomorrow |
| Unknown | Indicates that the filter is unknown |
| ValueBetween | A numeric or string filter - Value Between |
| ValueEqual | A numeric or string filter - Equal |
| ValueGreaterThan | A numeric or string filter - GreaterThan |
| ValueGreaterThanOrEqual | A numeric or string filter - Greater Than Or Equal |
| ValueLessThan | A numeric or string filter - Less Than |
| ValueLessThanOrEqual | A numeric or string filter - Less Than Or Equal |
| ValueNotBetween | A numeric or string filter - Not Between |
| ValueNotEqual | A numeric or string filter - Not Equal |
| YearToDate | A date filter - Year to date |
| Yesterday | A date filter - Yesterday |