PivotFilter.FilterType Property
Gets the type of the pivot filter.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v23.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Property Value
| Type | Description |
|---|---|
| PivotFilterType | A PivotFilterType enumeration member which indicates the filter type. |
Available values:
| 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. |