PivotFilterValues Enumeration
Pivot Filter Types
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
Public Enumeration PivotFilterValues
'Usage
Dim instance As PivotFilterValues
public enum PivotFilterValues
Members
| Member name | Description | |
|---|---|---|
| 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". |