officefileapi-devexpress-dot-spreadsheet-4d52eae1.md
Lists values that specify the type of filter to be applied to a PivotTable field.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public enum PivotFilterType
Public Enum PivotFilterType
| 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.
|
The following properties accept/return PivotFilterType values:
The PivotFilterType enumeration member is passed to the PivotFilterCollection.Add method as a parameter. Subsequently, it is the value of the PivotFilter.FilterType property.
See Also