ASP.NET Core

Code Examples Upgrade Guide User Guide Demos Support Forums Download
  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Enum PivotFilterType

    Show / Hide Table of Contents

    Enum PivotFilterType

    Pivot filter type

    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.Base.dll
    Syntax
    public enum PivotFilterType

    Fields

    Name Description
    CaptionBeginsWith

    Indicates the "begins with" filter for field captions.

    CaptionBetween

    Indicates the "is between" filter for field captions.

    CaptionContains

    Indicates the "contains" filter for field captions.

    CaptionEndsWith

    Indicates the "ends with" filter for field captions.

    CaptionEqual

    Indicates the "equal" filter for field captions.

    CaptionGreaterThan

    Indicates the "is greater than" filter for field captions

    CaptionGreaterThanOrEqual

    Indicates the "is greater than or equal to" filter for field captions.

    CaptionLessThan

    Indicates the "is less than" filter for field captions.

    CaptionLessThanOrEqual

    Indicates the "is less than or equal to" filter for field captions.

    CaptionNotBeginsWith

    Indicates the "does not begin with" filter for field captions.

    CaptionNotBetween

    Indicates the "is not between" filter for field captions.

    CaptionNotContains

    Indicates the "does not contain" filter for field captions.

    CaptionNotEndsWith

    Indicates the "does not end with" filter for field captions.

    CaptionNotEqual

    Indicates the "not equal" filter for field captions.

    Count

    Indicates the "count" filter.

    DateBetween

    Indicates the "dateBetween" filter.

    DateEqual

    Indicates the "dateEqual" filter.

    dateNewerThan

    Indicates the "dateNewerThan" filter.

    DateNewerThanOrEqual

    Indicates the "dateNewerThanOrEqual" filter.

    DateNotBetween

    Indicates the "dateNotBetween" filter.

    DateNotEqual

    Indicates the "dateNotEqual" filter.

    DateOlderThan

    Indicates the "dateOlderThan" filter.

    DateOlderThanOrEqual

    Indicates the "dateOlderThanOrEqual" filter.

    LastMonth

    Indicates the "lastMonth" filter.

    LastQuarter

    Indicates the "lastQuarter" filter.

    LastWeek

    Indicates the "lastWeek" filter.

    LastYear

    Indicates the "lastYear" filter.

    M1

    Indicates the "M1" filter.

    M10

    Indicates the "M10" filter.

    M11

    Indicates the "M11" filter.

    M12

    Indicates the "M12" filter.

    M2

    Indicates the "M2" filter.

    M3

    Indicates the "M3" filter.

    M4

    Indicates the "M4" filter.

    M5

    Indicates the "M5" filter.

    M6

    Indicates the "M6" filter.

    M7

    Indicates the "M7" filter.

    M8

    Indicates the "M8" filter.

    M9

    Indicates the "M9" filter.

    NextMonth

    Indicates the "nextMonth" filter.

    NextQuarter

    Indicates the "nextQuarter" filter.

    NextYear

    Indicates the "nextYear" filter.

    NexWeek

    Indicates the "nextWeek" filter.

    Percent

    Indicates the "percent" filter.

    Q1

    Indicates the "Q1" filter.

    Q2

    Indicates the "Q2" filter.

    Q3

    Indicates the "Q3" filter.

    Q4

    Indicates the "Q4" filter.

    Sum

    Indicates the "sum" filter.

    ThisMonth

    Indicates the "thisMonth" filter.

    ThisQuarter

    Indicates the "thisQuarter" filter.

    ThisWeek

    Indicates the "thisWeek" filter.

    ThisYear

    Indicates the "thisYear" filter.

    Today

    Indicates the "today" filter.

    Tomorrow

    Indicates the "tomorrow" filter.

    Unknown

    Indicates the "unknown" filter.

    ValueBetween

    Indicates the "Value between" filter for text and numeric values.

    ValueEqual

    Indicates the "value equal" filter for text and numeric values.

    ValueGreaterThan

    Indicates the "value greater than" filter for text and numeric values.

    ValueGreaterThanOrEqual

    Indicates the "value greater than or equal to" filter for text and numeric values.

    ValueLessThan

    Indicates the "value less than" filter for text and numeric values.

    ValueLessThanOrEqual

    Indicates the "value less than or equal to" filter for text and numeric values

    ValueNotBetween

    Indicates the "value not between" filter for text and numeric values.

    ValueNotEqual

    Indicates the "value not equal" filter for text and numeric values.

    yearToDate

    Indicates the "yearToDate" filter.

    Yesterday

    Indicates the "yesterday" filter.

    Back to top Generated by DocFX
    Copyright © 2001 - 2023 Syncfusion Inc. All Rights Reserved