XlPivotFilterType enumeration
Office 2013 and later
The type of filter applied.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
| Member name | Description | |
|---|---|---|
| xlTopCount | Filters for the specified number of values from the top of a list | |
| xlBottomCount | Filters for the specified number of values from the bottom of a list | |
| xlTopPercent | Filters for the specified percentage of values from a list | |
| xlBottomPercent | Filters for the specified percentage of values from the bottom of a list | |
| xlTopSum | Sum of the values from the top of the list | |
| xlBottomSum | Sum of the values from the bottom of the list | |
| xlValueEquals | Filters for all values that match the specified value | |
| xlValueDoesNotEqual | Filters for all values that do not match the specified value | |
| xlValueIsGreaterThan | Filters for all values that are greater than the specified value | |
| xlValueIsGreaterThanOrEqualTo | Filters for all values that are greater than or match the specified value | |
| xlValueIsLessThan | Filters for all values that are less than the specified value | |
| xlValueIsLessThanOrEqualTo | Filters for all values that are less than or match the specified value | |
| xlValueIsBetween | Filters for all values that are between a specified range of values | |
| xlValueIsNotBetween | Filters for all values that are not between a specified range of values | |
| xlCaptionEquals | Filters for all captions that match the specified string | |
| xlCaptionDoesNotEqual | Filters for all captions that do not match the specified string | |
| xlCaptionBeginsWith | Filters for all captions beginning with the specified string | |
| xlCaptionDoesNotBeginWith | Filters for all captions that do not begin with the specified string | |
| xlCaptionEndsWith | Filters for all captions that end with the specified string | |
| xlCaptionDoesNotEndWith | Filters for all captions that do not end with the specified string | |
| xlCaptionContains | Filters for all captions that contain the specified string | |
| xlCaptionDoesNotContain | Filters for all captions that do not contain the specified string | |
| xlCaptionIsGreaterThan | Filters for all captions that are greater than the specified value | |
| xlCaptionIsGreaterThanOrEqualTo | Filters for all captions that are greater than or match the specified value | |
| xlCaptionIsLessThan | Filters for all captions that are less than the specified value | |
| xlCaptionIsLessThanOrEqualTo | Filters for all captions that are less than or match the specified value | |
| xlCaptionIsBetween | Filters for all captions that are between a specified range of values | |
| xlCaptionIsNotBetween | Filters for all captions that are not between a specified range of values | |
| xlSpecificDate | Filters for all dates that match a specified date | |
| xlNotSpecificDate | Filters for all dates that do not match a specified date | |
| xlBefore | Filters for all dates before a specified date | |
| xlBeforeOrEqualTo | Filters for all dates on or before a specified date | |
| xlAfter | Filters for all dates after a specified date | |
| xlAfterOrEqualTo | Filters for all dates on or after a specified date | |
| xlDateBetween | Filters for all dates that are between a specified range of dates | |
| xlDateNotBetween | ||
| xlDateTomorrow | Filters for all dates that apply to the next day | |
| xlDateToday | Filters for all dates that apply to the current date | |
| xlDateYesterday | Filters for all dates that apply to the previous day | |
| xlDateNextWeek | Filters for all dates that apply to the next week | |
| xlDateThisWeek | Filters for all dates that apply to the current week | |
| xlDateLastWeek | Filters for all dates that apply to the previous week | |
| xlDateNextMonth | Filters for all dates that apply to the next month | |
| xlDateThisMonth | Filters for all dates that apply to the current month | |
| xlDateLastMonth | Filters for all dates that apply to the previous month | |
| xlDateNextQuarter | Filters for all dates that apply to the next quarter | |
| xlDateThisQuarter | Filters for all dates that apply to the current quarter | |
| xlDateLastQuarter | Filters for all dates that apply to the previous quarter | |
| xlDateNextYear | Filters for all dates that apply to the next year | |
| xlDateThisYear | Filters for all dates that apply to the current year | |
| xlDateLastYear | Filters for all dates that apply to the previous year | |
| xlYearToDate | Filters for all values that are within one year of a specified date | |
| xlAllDatesInPeriodQuarter1 | Filters for all dates in Quarter1 | |
| xlAllDatesInPeriodQuarter2 | Filters for all dates in Quarter2 | |
| xlAllDatesInPeriodQuarter3 | Filters for all dates in Quarter3 | |
| xlAllDatesInPeriodQuarter4 | Filters for all dates in Quarter 4 | |
| xlAllDatesInPeriodJanuary | Filters for all dates in January | |
| xlAllDatesInPeriodFebruary | Filters for all dates in February | |
| xlAllDatesInPeriodMarch | Filters for all dates in March | |
| xlAllDatesInPeriodApril | Filters for all dates in April | |
| xlAllDatesInPeriodMay | Filters for all dates in May | |
| xlAllDatesInPeriodJune | Filters for all dates in June | |
| xlAllDatesInPeriodJuly | Filters for all dates in July | |
| xlAllDatesInPeriodAugust | Filters for all dates in August | |
| xlAllDatesInPeriodSeptember | Filters for all dates in September | |
| xlAllDatesInPeriodOctober | Filters for all dates in October | |
| xlAllDatesInPeriodNovember | Filters for all dates in November | |
| xlAllDatesInPeriodDecember | Filters for all dates in December |
Show: