Enumeration Value

Description

captionBeginsWith (Caption Begins With)

Indicates the "begins with" filter for field captions.

captionBetween (Caption Is Between)

Indicates the "is between" filter for field captions.

captionContains (Caption Contains)

Indicates the "contains" filter for field captions.

captionEndsWith (Caption Ends With)

Indicates the "ends with" filter for field captions.

captionEqual (Caption Equals)

Indicates the "equal" filter for field captions.

captionGreaterThan (Caption Is Greater Than)

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

captionGreaterThanOrEqual (Caption Is Greater Than Or Equal To)

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

captionLessThan (Caption Is Less Than)

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

captionLessThanOrEqual (Caption Is Less Than Or Equal To)

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

captionNotBeginsWith (Caption Does Not Begin With)

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

captionNotBetween (Caption Is Not Between)

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

captionNotContains (Caption Does Not Contain)

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

captionNotEndsWith (Caption Does Not End With)

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

captionNotEqual (Caption Not Equal)

Indicates the "not equal" filter for field captions.

count (Count)

Indicates the "count" filter.

dateBetween (Date Between)

Indicates the "between" filter for date values.

dateEqual (Date Equals)

Indicates the "equals" filter for date values.

dateNewerThan (Date Newer Than)

Indicates the "newer than" filter for date values.

dateNewerThanOrEqual (Date Newer Than or Equal To)

Indicates the "newer than or equal to" filter for date values.

dateNotBetween (Date Not Between)

Indicates the "not between" filter for date values.

dateNotEqual (Date Does Not Equal)

Indicates the "does not equal" filter for date values.

dateOlderThan (Date Older Than)

Indicates the "older than" filter for date values.

dateOlderThanOrEqual (Date Older Than Or Equal)

Indicates the "older than or equal to" filter for date values.

lastMonth (Last Month)

Indicates the "last month" filter for date values.

lastQuarter (Last Quarter)

Indicates the "last quarter" filter for date values.

lastWeek (Last Week)

Indicates the "last week" filter for date values.

lastYear (Last Year)

Indicates the "last year" filter for date values.

M1 (January)

Indicates the "January" filter for date values.

M10 (Dates in October)

Indicates the "October" filter for date values.

M11 (Dates in November)

Indicates the "November" filter for date values.

M12 (Dates in December)

Indicates the "December" filter for date values.

M2 (Dates in February)

Indicates the "February" filter for date values.

M3 (Dates in March)

Indicates the "March" filter for date values.

M4 (Dates in April)

Indicates the "April" filter for date values.

M5 (Dates in May)

Indicates the "May" filter for date values.

M6 (Dates in June)

Indicates the "June" filter for date values.

M7 (Dates in July)

Indicates the "July" filter for date values.

M8 (Dates in August)

Indicates the "August" filter for date values.

M9 (Dates in September)

Indicates the "September" filter for date values.

nextMonth (Next Month)

Indicates the "next month" filter for date values.

nextQuarter (Next Quarter)

Indicates the "next quarter" for date values.

nextWeek (Next Week)

Indicates the "next week" for date values.

nextYear (Next Year)

Indicates the "next year" filter for date values.

percent (Percent)

Indicates the "percent" filter for numeric values.

Q1 (First Quarter)

Indicates the "first quarter" filter for date values.

Q2 (Second Quarter)

Indicates the "second quarter" filter for date values.

Q3 (Third Quarter)

Indicates the "third quarter" filter for date values.

Q4 (Fourth Quarter)

Indicates the "fourth quarter" filter for date values.

sum (Sum)

Indicates the "sum" filter for numeric values.

thisMonth (This Month)

Indicates the "this month" filter for date values.

thisQuarter (This Quarter)

Indicates the "this quarter" filter for date values.

thisWeek (This Week)

Indicates the "this week" filter for date values.

thisYear (This Year)

Indicate the "this year" filter for date values.

today (Today)

Indicates the "today" filter for date values.

tomorrow (Tomorrow)

Indicates the "tomorrow" filter for date values.

unknown (Unknown)

Indicates the PivotTable filter is unknown to the application.

valueBetween (Value Between)

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

valueEqual (Value Equal)

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

valueGreaterThan (Value Greater Than)

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

valueGreaterThanOrEqual (Value Greater Than Or Equal To)

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

valueLessThan (Value Less Than)

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

valueLessThanOrEqual (Value Less Than Or Equal To)

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

valueNotBetween (Value Not Between)

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

valueNotEqual (Value Not Equal)

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

yearToDate (Year-To-Date)

Indicates the "year-to-date" filter for date values.

yesterday (Yesterday)

Indicates the "yesterday" filter for date values.

Referenced By

filter@type (§3.10.1.33)