Skip to main content

XlPivotFilterType

The pivot filter type.

Type​

Enumeration

Values​

  • "xlAfter"
  • "xlAfterOrEqualTo"
  • "xlAllDatesInPeriodApril"
  • "xlAllDatesInPeriodAugust"
  • "xlAllDatesInPeriodDecember"
  • "xlAllDatesInPeriodFebruary"
  • "xlAllDatesInPeriodJanuary"
  • "xlAllDatesInPeriodJuly"
  • "xlAllDatesInPeriodJune"
  • "xlAllDatesInPeriodMarch"
  • "xlAllDatesInPeriodMay"
  • "xlAllDatesInPeriodNovember"
  • "xlAllDatesInPeriodOctober"
  • "xlAllDatesInPeriodQuarter1"
  • "xlAllDatesInPeriodQuarter2"
  • "xlAllDatesInPeriodQuarter3"
  • "xlAllDatesInPeriodQuarter4"
  • "xlAllDatesInPeriodSeptember"
  • "xlBefore"
  • "xlBeforeOrEqualTo"
  • "xlBottomCount"
  • "xlBottomPercent"
  • "xlBottomSum"
  • "xlCaptionBeginsWith"
  • "xlCaptionContains"
  • "xlCaptionDoesNotBeginWith"
  • "xlCaptionDoesNotContain"
  • "xlCaptionDoesNotEndWith"
  • "xlCaptionDoesNotEqual"
  • "xlCaptionEndsWith"
  • "xlCaptionEquals"
  • "xlCaptionIsBetween"
  • "xlCaptionIsGreaterThan"
  • "xlCaptionIsGreaterThanOrEqualTo"
  • "xlCaptionIsLessThan"
  • "xlCaptionIsLessThanOrEqualTo"
  • "xlCaptionIsNotBetween"
  • "xlDateBetween"
  • "xlDateLastMonth"
  • "xlDateLastQuarter"
  • "xlDateLastWeek"
  • "xlDateLastYear"
  • "xlDateNextMonth"
  • "xlDateNextQuarter"
  • "xlDateNextWeek"
  • "xlDateNextYear"
  • "xlDateThisMonth"
  • "xlDateThisQuarter"
  • "xlDateThisWeek"
  • "xlDateThisYear"
  • "xlDateToday"
  • "xlDateTomorrow"
  • "xlDateYesterday"
  • "xlNotSpecificDate"
  • "xlSpecificDate"
  • "xlTopCount"
  • "xlTopPercent"
  • "xlTopSum"
  • "xlValueDoesNotEqual"
  • "xlValueEquals"
  • "xlValueIsBetween"
  • "xlValueIsGreaterThan"
  • "xlValueIsGreaterThanOrEqualTo"
  • "xlValueIsLessThan"
  • "xlValueIsLessThanOrEqualTo"
  • "xlValueIsNotBetween"
  • "xlYearToDate"