Skip to main content
Row

PivotFilter.FilterType Property

Gets the type of the pivot filter.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

PivotFilterType FilterType { get; }

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.

See Also