The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PivotFilterType Enum

Lists values that specify the type of filter to be applied to a PivotTable field.

Namespace: DevExpress.Spreadsheet

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

Declaration

public enum PivotFilterType
Public Enum PivotFilterType
public enum PivotFilterType
Public Enum PivotFilterType

Members

Name Description
April

Shows dates occurring in April, regardless of the year.

August

Shows dates occurring in August, regardless of the year.

CaptionBeginsWith

Shows item labels that begin with the specified text string.

CaptionBetween

Shows item labels that are between a specified range of values.

CaptionContains

Shows item labels that contain the specified text string.

CaptionEndsWith

Shows item labels that end with the specified text string.

CaptionEqual

Shows item labels that match a specified value.

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.

CaptionNotBeginsWith

Shows item labels that do not begin with the specified text string.

CaptionNotBetween

Shows item labels that are not between a specified range of values.

CaptionNotContains

Shows item labels that do not contain the specified text string.

CaptionNotEndsWith

Shows item labels that do not end with the specified text string.

CaptionNotEqual

Shows item labels that do not match a specified value.

Count

Shows the specified number of items containing top/bottom values.

DateBetween

Shows dates that are between a specified range of dates.

DateEqual

Shows dates that match a specified date.

DateNewerThan

Shows dates after a specified date.

DateNewerThanOrEqual

Shows dates that are after or equal to a specified date.

DateNotBetween

Shows dates that are not between a specified range of dates.

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.

December

Shows dates occurring in December, regardless of the year.

February

Shows dates occurring in February, regardless of the year.

FirstQuarter

Shows dates occurring in the 1st quarter, regardless of the year.

FourthQuarter

Shows dates occurring in the 4th quarter, regardless of the year.

January

Shows dates occurring in January, regardless of the year.

July

Shows dates occurring in July, regardless of the year.

June

Shows dates occurring in June, regardless of the year.

LastMonth

Shows dates occurring last month.

LastQuarter

Shows dates occurring last quarter.

LastWeek

Shows dates occurring last week.

LastYear

Shows dates occurring last year.

March

Shows dates occurring in March, regardless of the year.

May

Shows dates occurring in May, regardless of the year.

NextMonth

Shows dates occurring next month.

NextQuarter

Shows dates occurring next quarter.

NextWeek

Shows dates occurring next week.

NextYear

Shows dates occurring next year.

November

Shows dates occurring in November, regardless of the year.

October

Shows dates occurring in October, regardless of the year.

Percent

Shows top/bottom items that comprise not less than the specified percent of the total of the field values.

SecondQuarter

Shows dates occurring in the 2nd quarter, regardless of the year.

September

Shows dates occurring in September, regardless of the year.

Sum

Shows top/bottom items that comprise not less than the specified sum of the values.

ThirdQuarter

Shows dates occurring in the 3rd quarter, regardless of the year.

ThisMonth

Shows dates occurring this month.

ThisQuarter

Shows dates occurring this quarter.

ThisWeek

Shows dates occurring this week.

ThisYear

Shows dates occurring this year.

Today

Shows today's dates.

Tomorrow

Shows tomorrow's dates.

ValueBetween

Shows values that are between a specified range of values.

ValueEqual

Shows values that are 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.

ValueNotBetween

Shows values that are not between a specified range of values.

ValueNotEqual

Shows values that are not equal to a specified value

YearToDate

Shows dates occurring between the beginning of the current year and today, inclusive.

Yesterday

Shows yesterday's dates.

Remarks

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