Enum PivotFilterType
Namespace: DRIT.Spreadsheet.Pivot
Assembly: DRIT.Spreadsheet.dll
Syntax
public enum PivotFilterType : int
Fields
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 |