PivotFilterType Enum
Lists values that specify the type of filter to be applied to a PivotTable field.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Members
| Name | Description |
|---|---|
CaptionEqual
|
Shows item labels that match a specified value. |
CaptionNotEqual
|
Shows item labels that do not match a specified value. |
CaptionBeginsWith
|
Shows item labels that begin with the specified text string. |
CaptionNotBeginsWith
|
Shows item labels that do not begin with the specified text string. |
CaptionEndsWith
|
Shows item labels that end with the specified text string. |
CaptionNotEndsWith
|
Shows item labels that do not end with the specified text string. |
CaptionContains
|
Shows item labels that contain the specified text string. |
CaptionNotContains
|
Shows item labels that do not contain the specified text string. |
CaptionGreaterThan
|
Shows item labels that are greater than a specified value. |
CaptionGreaterThanOrEqual
|
Shows item labels that are greater than or equal to a specified value. |
CaptionLessThan
|
Shows item labels that are less than a specified value. |
CaptionLessThanOrEqual
|
Shows item labels that are less than or equal to a specified value. |
CaptionBetween
|
Shows item labels that are between a specified range of values. |
CaptionNotBetween
|
Shows item labels that are not between a specified range of values. |
Count
|
Shows the specified number of items containing top/bottom values. |
DateEqual
|
Shows dates that match a specified date. |
DateNotEqual
|
Shows dates that do not match a specified date. |
DateOlderThan
|
Shows dates before a specified date. |
DateOlderThanOrEqual
|
Shows dates that are before or equal to a specified date. |
DateNewerThan
|
Shows dates after a specified date. |
DateNewerThanOrEqual
|
Shows dates that are after or equal to a specified date. |
DateBetween
|
Shows dates that are between a specified range of dates. |
DateNotBetween
|
Shows dates that are not between a specified range of dates. |
LastWeek
|
Shows dates occurring last week. |
LastMonth
|
Shows dates occurring last month. |
LastQuarter
|
Shows dates occurring last quarter. |
LastYear
|
Shows dates occurring last year. |
January
|
Shows dates occurring in January, regardless of the year. |
February
|
Shows dates occurring in February, regardless of the year. |
March
|
Shows dates occurring in March, regardless of the year. |
April
|
Shows dates occurring in April, regardless of the year. |
May
|
Shows dates occurring in May, regardless of the year. |
June
|
Shows dates occurring in June, regardless of the year. |
July
|
Shows dates occurring in July, regardless of the year. |
August
|
Shows dates occurring in August, regardless of the year. |
September
|
Shows dates occurring in September, regardless of the year. |
October
|
Shows dates occurring in October, regardless of the year. |
November
|
Shows dates occurring in November, regardless of the year. |
December
|
Shows dates occurring in December, regardless of the year. |
NextWeek
|
Shows dates occurring next week. |
NextMonth
|
Shows dates occurring next month. |
NextQuarter
|
Shows dates occurring next quarter. |
NextYear
|
Shows dates occurring next year. |
Percent
|
Shows top/bottom items that comprise not less than the specified percent of the total of the field values. |
FirstQuarter
|
Shows dates occurring in the 1st quarter, regardless of the year. |
SecondQuarter
|
Shows dates occurring in the 2nd quarter, regardless of the year. |
ThirdQuarter
|
Shows dates occurring in the 3rd quarter, regardless of the year. |
FourthQuarter
|
Shows dates occurring in the 4th quarter, regardless of the year. |
Sum
|
Shows top/bottom items that comprise not less than the specified sum of the values. |
Tomorrow
|
Shows tomorrow’s dates. |
Today
|
Shows today’s dates. |
ThisWeek
|
Shows dates occurring this week. |
ThisMonth
|
Shows dates occurring this month. |
ThisQuarter
|
Shows dates occurring this quarter. |
ThisYear
|
Shows dates occurring this year. |
ValueEqual
|
Shows values that are equal to a specified value. |
ValueNotEqual
|
Shows values that are not equal to a specified value |
ValueGreaterThan
|
Shows values that are greater than a specified value. |
ValueGreaterThanOrEqual
|
Shows values that are greater than or equal to a specified value. |
ValueLessThan
|
Shows values that are less than a specified value. |
ValueLessThanOrEqual
|
Shows values that are less than or equal to a specified value. |
ValueBetween
|
Shows values that are between a specified range of values. |
ValueNotBetween
|
Shows values that are not between a specified range of values. |
Yesterday
|
Shows yesterday’s dates. |
YearToDate
|
Shows dates occurring between the beginning of the current year and today, inclusive. |
Related API Members
The following properties accept/return PivotFilterType values:
Remarks
The PivotFilterType enumeration member is passed to the PivotFilterCollection.Add method as a parameter. Subsequently, it is the value of the PivotFilter.FilterType property.