PivotFilterValues enumeration

Office 2013 and later

Pivot Filter Types

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

Member nameDescription
Unknown Unknown. When the item is serialized out as xml, its value is "unknown".
Count Count. When the item is serialized out as xml, its value is "count".
Percent Percent. When the item is serialized out as xml, its value is "percent".
Sum Sum. When the item is serialized out as xml, its value is "sum".
CaptionEqual Caption Equals. When the item is serialized out as xml, its value is "captionEqual".
CaptionNotEqual Caption Not Equal. When the item is serialized out as xml, its value is "captionNotEqual".
CaptionBeginsWith Caption Begins With. When the item is serialized out as xml, its value is "captionBeginsWith".
CaptionNotBeginsWith Caption Does Not Begin With. When the item is serialized out as xml, its value is "captionNotBeginsWith".
CaptionEndsWith Caption Ends With. When the item is serialized out as xml, its value is "captionEndsWith".
CaptionNotEndsWith Caption Does Not End With. When the item is serialized out as xml, its value is "captionNotEndsWith".
CaptionContains Caption Contains. When the item is serialized out as xml, its value is "captionContains".
CaptionNotContains Caption Does Not Contain. When the item is serialized out as xml, its value is "captionNotContains".
CaptionGreaterThan Caption Is Greater Than. When the item is serialized out as xml, its value is "captionGreaterThan".
CaptionGreaterThanOrEqual Caption Is Greater Than Or Equal To. When the item is serialized out as xml, its value is "captionGreaterThanOrEqual".
CaptionLessThan Caption Is Less Than. When the item is serialized out as xml, its value is "captionLessThan".
CaptionLessThanOrEqual Caption Is Less Than Or Equal To. When the item is serialized out as xml, its value is "captionLessThanOrEqual".
CaptionBetween Caption Is Between. When the item is serialized out as xml, its value is "captionBetween".
CaptionNotBetween Caption Is Not Between. When the item is serialized out as xml, its value is "captionNotBetween".
ValueEqual Value Equal. When the item is serialized out as xml, its value is "valueEqual".
ValueNotEqual Value Not Equal. When the item is serialized out as xml, its value is "valueNotEqual".
ValueGreaterThan Value Greater Than. When the item is serialized out as xml, its value is "valueGreaterThan".
ValueGreaterThanOrEqual Value Greater Than Or Equal To. When the item is serialized out as xml, its value is "valueGreaterThanOrEqual".
ValueLessThan Value Less Than. When the item is serialized out as xml, its value is "valueLessThan".
ValueLessThanOrEqual Value Less Than Or Equal To. When the item is serialized out as xml, its value is "valueLessThanOrEqual".
ValueBetween Value Between. When the item is serialized out as xml, its value is "valueBetween".
ValueNotBetween Value Not Between. When the item is serialized out as xml, its value is "valueNotBetween".
DateEqual Date Equals. When the item is serialized out as xml, its value is "dateEqual".
DateNotEqual Date Does Not Equal. When the item is serialized out as xml, its value is "dateNotEqual".
DateOlderThan Date Older Than. When the item is serialized out as xml, its value is "dateOlderThan".
DateOlderThanOrEqual Date Older Than Or Equal. When the item is serialized out as xml, its value is "dateOlderThanOrEqual".
DateNewerThan Date Newer Than. When the item is serialized out as xml, its value is "dateNewerThan".
DateNewerThanOrEqual Date Newer Than or Equal To. When the item is serialized out as xml, its value is "dateNewerThanOrEqual".
DateBetween Date Between. When the item is serialized out as xml, its value is "dateBetween".
DateNotBetween Date Not Between. When the item is serialized out as xml, its value is "dateNotBetween".
Tomorrow Tomorrow. When the item is serialized out as xml, its value is "tomorrow".
Today Today. When the item is serialized out as xml, its value is "today".
Yesterday Yesterday. When the item is serialized out as xml, its value is "yesterday".
NextWeek Next Week. When the item is serialized out as xml, its value is "nextWeek".
ThisWeek This Week. When the item is serialized out as xml, its value is "thisWeek".
LastWeek Last Week. When the item is serialized out as xml, its value is "lastWeek".
NextMonth Next Month. When the item is serialized out as xml, its value is "nextMonth".
ThisMonth This Month. When the item is serialized out as xml, its value is "thisMonth".
LastMonth Last Month. When the item is serialized out as xml, its value is "lastMonth".
NextQuarter Next Quarter. When the item is serialized out as xml, its value is "nextQuarter".
ThisQuarter This Quarter. When the item is serialized out as xml, its value is "thisQuarter".
LastQuarter Last Quarter. When the item is serialized out as xml, its value is "lastQuarter".
NextYear Next Year. When the item is serialized out as xml, its value is "nextYear".
ThisYear This Year. When the item is serialized out as xml, its value is "thisYear".
LastYear Last Year. When the item is serialized out as xml, its value is "lastYear".
YearToDate Year-To-Date. When the item is serialized out as xml, its value is "yearToDate".
Quarter1 First Quarter. When the item is serialized out as xml, its value is "Q1".
Quarter2 Second Quarter. When the item is serialized out as xml, its value is "Q2".
Quarter3 Third Quarter. When the item is serialized out as xml, its value is "Q3".
Quarter4 Fourth Quarter. When the item is serialized out as xml, its value is "Q4".
January January. When the item is serialized out as xml, its value is "M1".
February Dates in February. When the item is serialized out as xml, its value is "M2".
March Dates in March. When the item is serialized out as xml, its value is "M3".
April Dates in April. When the item is serialized out as xml, its value is "M4".
May Dates in May. When the item is serialized out as xml, its value is "M5".
June Dates in June. When the item is serialized out as xml, its value is "M6".
July Dates in July. When the item is serialized out as xml, its value is "M7".
August Dates in August. When the item is serialized out as xml, its value is "M8".
September Dates in September. When the item is serialized out as xml, its value is "M9".
October Dates in October. When the item is serialized out as xml, its value is "M10".
November Dates in November. When the item is serialized out as xml, its value is "M11".
December Dates in December. When the item is serialized out as xml, its value is "M12".
Show: