Show / Hide Table of Contents

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
Back to top Generated by DocFX