PivotFilter.FilterType Property

Gets the type of the pivot filter.

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

C#
VB.NET

csharp

PivotFilterType FilterType { get; }

ReadOnly Property FilterType As PivotFilterType

Property Value

Type	Description
PivotFilterType

A PivotFilterType enumeration member which indicates the filter type.

Available values:

Show 65 items

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.