Enum PivotFilterType
Namespace: DRIT.Spreadsheet.Pivot
Assembly: DRIT.Spreadsheet.dll
Syntax
public enum PivotFilterType : intFields
| Name | Description |
|---|---|
| CaptionBeginsWith | |
| CaptionBetween | |
| CaptionContains | |
| CaptionEndsWith | |
| CaptionEqual | "equals" filter for field captions |
| CaptionGreaterThan | |
| CaptionGreaterThanOrEqual | |
| CaptionLessThan | |
| CaptionLessThanOrEqual | |
| CaptionNotBeginsWith | |
| CaptionNotBetween | |
| CaptionNotContains | |
| CaptionNotEndsWith | |
| CaptionNotEqual | |
| Count | "count" filter |
| DateBetween | |
| DateEqual | |
| DateNewerThan | |
| DateNewerThanOrEqual | |
| DateNotBetween | |
| DateNotEqual | |
| DateOlderThan | |
| DateOlderThanOrEqual | |
| LastMonth | |
| LastQuarter | |
| LastWeek | |
| LastYear | |
| M1 | |
| M10 | |
| M11 | |
| M12 | |
| M2 | |
| M3 | |
| M4 | |
| M5 | |
| M6 | |
| M7 | |
| M8 | |
| M9 | |
| NextMonth | |
| NextQuarter | |
| NextWeek | |
| NextYear | |
| Percent | "percent" filter for numeric values |
| Q1 | |
| Q2 | |
| Q3 | |
| Q4 | |
| Sum | "sum" filter for numeric values |
| ThisMonth | |
| ThisQuarter | |
| ThisWeek | |
| ThisYear | |
| Today | |
| Tomorrow | |
| Unknown | |
| ValueBetween | |
| ValueEqual | |
| ValueGreaterThan | |
| ValueGreaterThanOrEqual | |
| ValueLessThan | |
| ValueLessThanOrEqual | |
| ValueNotBetween | |
| ValueNotEqual | |
| YearToDate | |
| Yesterday |