This documentation is archived and is not being maintained.

XlPivotFilterType Enumeration

The type of filter applied.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

public enum XlPivotFilterType

Member nameDescription
xlTopCountFilters for the specified number of values from the top of a list
xlBottomCountFilters for the specified number of values from the bottom of a list
xlTopPercentFilters for the specified percentage of values from a list
xlBottomPercentFilters for the specified percentage of values from the bottom of a list
xlTopSumSum of the values from the top of the list
xlBottomSumSum of the values from the bottom of the list
xlValueEqualsFilters for all values that match the specified value
xlValueDoesNotEqualFilters for all values that do not match the specified value
xlValueIsGreaterThanFilters for all values that are greater than the specified value
xlValueIsGreaterThanOrEqualToFilters for all values that are greater than or match the specified value
xlValueIsLessThanFilters for all values that are less than the specified value
xlValueIsLessThanOrEqualToFilters for all values that are less than or match the specified value
xlValueIsBetweenFilters for all values that are between a specified range of values
xlValueIsNotBetweenFilters for all values that are not between a specified range of values
xlCaptionEqualsFilters for all captions that match the specified string
xlCaptionDoesNotEqualFilters for all captions that do not match the specified string
xlCaptionBeginsWithFilters for all captions beginning with the specified string
xlCaptionDoesNotBeginWithFilters for all captions that do not begin with the specified string
xlCaptionEndsWithFilters for all captions that end with the specified string
xlCaptionDoesNotEndWithFilters for all captions that do not end with the specified string
xlCaptionContainsFilters for all captions that contain the specified string
xlCaptionDoesNotContainFilters for all captions that do not contain the specified string
xlCaptionIsGreaterThanFilters for all captions that are greater than the specified value
xlCaptionIsGreaterThanOrEqualToFilters for all captions that are greater than or match the specified value
xlCaptionIsLessThanFilters for all captions that are less than the specified value
xlCaptionIsLessThanOrEqualToFilters for all captions that are less than or match the specified value
xlCaptionIsBetweenFilters for all captions that are between a specified range of values
xlCaptionIsNotBetweenFilters for all captions that are not between a specified range of values
xlSpecificDateFilters for all dates that match a specified date
xlNotSpecificDateFilters for all dates that do not match a specified date
xlBeforeFilters for all dates before a specified date
xlBeforeOrEqualToFilters for all dates on or before a specified date
xlAfterFilters for all dates after a specified date
xlAfterOrEqualToFilters for all dates on or after a specified date
xlDateBetweenFilters for all dates that are between a specified range of dates
xlDateNotBetween
xlDateTomorrowFilters for all dates that apply to the next day
xlDateTodayFilters for all dates that apply to the current date
xlDateYesterdayFilters for all dates that apply to the previous day
xlDateNextWeekFilters for all dates that apply to the next week
xlDateThisWeekFilters for all dates that apply to the current week
xlDateLastWeekFilters for all dates that apply to the previous week
xlDateNextMonthFilters for all dates that apply to the next month
xlDateThisMonthFilters for all dates that apply to the current month
xlDateLastMonthFilters for all dates that apply to the previous month
xlDateNextQuarterFilters for all dates that apply to the next quarter
xlDateThisQuarterFilters for all dates that apply to the current quarter
xlDateLastQuarterFilters for all dates that apply to the previous quarter
xlDateNextYearFilters for all dates that apply to the next year
xlDateThisYearFilters for all dates that apply to the current year
xlDateLastYearFilters for all dates that apply to the previous year
xlYearToDateFilters for all values that are within one year of a specified date
xlAllDatesInPeriodQuarter1Filters for all dates in Quarter1
xlAllDatesInPeriodQuarter2Filters for all dates in Quarter2
xlAllDatesInPeriodQuarter3Filters for all dates in Quarter3
xlAllDatesInPeriodQuarter4Filters for all dates in Quarter 4
xlAllDatesInPeriodJanuaryFilters for all dates in January
xlAllDatesInPeriodFebruaryFilters for all dates in February
xlAllDatesInPeriodMarchFilters for all dates in March
xlAllDatesInPeriodAprilFilters for all dates in April
xlAllDatesInPeriodMayFilters for all dates in May
xlAllDatesInPeriodJuneFilters for all dates in June
xlAllDatesInPeriodJulyFilters for all dates in July
xlAllDatesInPeriodAugustFilters for all dates in August
xlAllDatesInPeriodSeptemberFilters for all dates in September
xlAllDatesInPeriodOctoberFilters for all dates in October
xlAllDatesInPeriodNovemberFilters for all dates in November
xlAllDatesInPeriodDecemberFilters for all dates in December
Show: