PivotFilter.FilterType Property

Gets the type of the pivot filter.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

PivotFilterType FilterType { get; }

VB.NET

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.