PivotFilter.FilterType Property
Gets the type of the pivot filter.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
#Declaration
PivotFilterType FilterType { get; }
#Property Value
Type | Description |
---|---|
Pivot |
A Pivot |
Available values:
Name | Description |
---|---|
Caption |
Shows item labels that match a specified value. |
Caption |
Shows item labels that do not match a specified value. |
Caption |
Shows item labels that begin with the specified text string. |
Caption |
Shows item labels that do not begin with the specified text string. |
Caption |
Shows item labels that end with the specified text string. |
Caption |
Shows item labels that do not end with the specified text string. |
Caption |
Shows item labels that contain the specified text string. |
Caption |
Shows item labels that do not contain the specified text string. |
Caption |
Shows item labels that are greater than a specified value. |
Caption |
Shows item labels that are greater than or equal to a specified value. |
Caption |
Shows item labels that are less than a specified value. |
Caption |
Shows item labels that are less than or equal to a specified value. |
Caption |
Shows item labels that are between a specified range of values. |
Caption |
Shows item labels that are not between a specified range of values. |
Count | Shows the specified number of items containing top/bottom values. |
Date |
Shows dates that match a specified date. |
Date |
Shows dates that do not match a specified date. |
Date |
Shows dates before a specified date. |
Date |
Shows dates that are before or equal to a specified date. |
Date |
Shows dates after a specified date. |
Date |
Shows dates that are after or equal to a specified date. |
Date |
Shows dates that are between a specified range of dates. |
Date |
Shows dates that are not between a specified range of dates. |
Last |
Shows dates occurring last week. |
Last |
Shows dates occurring last month. |
Last |
Shows dates occurring last quarter. |
Last |
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. |
Next |
Shows dates occurring next week. |
Next |
Shows dates occurring next month. |
Next |
Shows dates occurring next quarter. |
Next |
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. |
First |
Shows dates occurring in the 1st quarter, regardless of the year. |
Second |
Shows dates occurring in the 2nd quarter, regardless of the year. |
Third |
Shows dates occurring in the 3rd quarter, regardless of the year. |
Fourth |
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. |
This |
Shows dates occurring this week. |
This |
Shows dates occurring this month. |
This |
Shows dates occurring this quarter. |
This |
Shows dates occurring this year. |
Value |
Shows values that are equal to a specified value. |
Value |
Shows values that are not equal to a specified value |
Value |
Shows values that are greater than a specified value. |
Value |
Shows values that are greater than or equal to a specified value. |
Value |
Shows values that are less than a specified value. |
Value |
Shows values that are less than or equal to a specified value. |
Value |
Shows values that are between a specified range of values. |
Value |
Shows values that are not between a specified range of values. |
Yesterday | Shows yesterday’s dates. |
Year |
Shows dates occurring between the beginning of the current year and today, inclusive. |