This documentation is archived and is not being maintained.

XlPivotFilterType Enumeration

Office 2007
The type of filter applied.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlBefore31Filters for all dates before a specified date
xlBeforeOrEqualTo32Filters for all dates on or before a specified date
xlAfter33Filters for all dates after a specified date
xlAfterOrEqualTo34Filters for all dates on or after a specified date
xlAllDatesInPeriodJanuary53Filters for all dates in January
xlAllDatesInPeriodFebruary54Filters for all dates in February
xlAllDatesInPeriodMarch55Filters for all dates in March
xlAllDatesInPeriodApril56Filters for all dates in April
xlAllDatesInPeriodMay57Filters for all dates in May
xlAllDatesInPeriodJune58Filters for all dates in June
xlAllDatesInPeriodJuly59Filters for all dates in July
xlAllDatesInPeriodAugust60Filters for all dates in August
xlAllDatesInPeriodSeptember61Filters for all dates in September
xlAllDatesInPeriodOctober62Filters for all dates in October
xlAllDatesInPeriodNovember63Filters for all dates in November
xlAllDatesInPeriodDecember64Filters for all dates in December
xlAllDatesInPeriodQuarter149Filters for all dates in Quarter1
xlAllDatesInPeriodQuarter250Filters for all dates in Quarter2
xlAllDatesInPeriodQuarter351Filters for all dates in Quarter3
xlAllDatesInPeriodQuarter452Filters for all dates in Quarter 4
xlBottomCount2Filters for the specified number of values from the bottom of a list
xlBottomPercent4Filters for the specified percentage of values from the bottom of a list
xlBottomSum6Sum of the values from the bottom of the list
xlCaptionBeginsWith17Filters for all captions beginning with the specified string
xlCaptionContains21Filters for all captions that contain the specified string
xlCaptionDoesNotBeginWith18Filters for all captions that do not begin with the specified string
xlCaptionDoesNotContain22Filters for all captions that do not contain the specified string
xlCaptionDoesNotEndWith20Filters for all captions that do not end with the specified string
xlCaptionDoesNotEqual16Filters for all captions that do not match the specified string
xlCaptionEndsWith19Filters for all captions that end with the specified string
xlCaptionEquals15Filters for all captions that match the specified string
xlCaptionIsBetween27Filters for all captions that are between a specified range of values
xlCaptionIsGreaterThan23Filters for all captions that are greater than the specified value
xlCaptionIsGreaterThanOrEqualTo24Filters for all captions that are greater than or match the specified value
xlCaptionIsLessThan25Filters for all captions that are less than the specified value
xlCaptionIsLessThanOrEqualTo26Filters for all captions that are less than or match the specified value
xlCaptionIsNotBetween28Filters for all captions that are not between a specified range of values
xlDateBetween32Filters for all dates that are between a specified range of dates
xlDateLastMonth41Filters for all dates that apply to the previous month
xlDateLastQuarter44Filters for all dates that apply to the previous quarter
xlDateLastWeek38Filters for all dates that apply to the previous week
xlDateLastYear47Filters for all dates that apply to the previous year
xlDateNextMonth39Filters for all dates that apply to the next month
xlDateNextQuarter42Filters for all dates that apply to the next quarter
xlDateNextWeek36Filters for all dates that apply to the next week
xlDateNextYear45Filters for all dates that apply to the next year
xlDateThisMonth40Filters for all dates that apply to the current month
xlDateThisQuarter43Filters for all dates that apply to the current quarter
xlDateThisWeek37Filters for all dates that apply to the current week
xlDateThisYear46Filters for all dates that apply to the current year
xlDateToday34Filters for all dates that apply to the current date
xlDateTomorrow33Filters for all dates that apply to the next day
xlDateYesterday35Filters for all dates that apply to the previous day
xlNotSpecificDate30Filters for all dates that do not match a specified date
xlSpecificDate29Filters for all dates that match a specified date
xlTopCount1Filters for the specified number of values from the top of a list
xlTopPercent3Filters for the specified percentage of values from a list
xlTopSum5Sum of the values from the top of the list
xlValueDoesNotEqual8Filters for all values that do not match the specified value
xlValueEquals7Filters for all values that match the specified value
xlValueIsBetween13Filters for all values that are between a specified range of values
xlValueIsGreaterThan9Filters for all values that are greater than the specified value
xlValueIsGreaterThanOrEqualTo10Filters for all values that are greater than or match the specified value
xlValueIsLessThan11Filters for all values that are less than the specified value
xlValueIsLessThanOrEqualTo12Filters for all values that are less than or match the specified value
xlValueIsNotBetween14Filters for all values that are not between a specified range of values
xlYearToDate48Filters for all values that are within one year of a specified date


Show: