PivotField.ClearLabelFilters Method (Excel)
This method deletes all label filters or all date filters in the PivotFilters collection of the PivotField.
Version Information
Version Added: Excel 2007
Syntax
expression .ClearLabelFilters
expression A variable that represents a PivotField object.
Remarks
The following table lists the different label filter types that will be deleted by this method.
xlCaptionEquals |
xlCaptionDoesNotEqual |
xlCaptionIsGreaterThan |
xlCaptionIsGreaterThanOrEqualTo |
xlCaptionIsLessThan |
xlCaptionIsLessThanOrEqualTo |
xlCaptionBeginsWith |
xlCaptionDoesNotBeginWith |
xlCaptionEndsWith |
xlCaptionDoesNotEndWith |
xlCaptionContains |
xlCaptionDoesNotContain |
xlCaptionIsBetween |
xlCaptionIsNotBetween |
The following table lists the different date filter types that will be deleted by this method.
xlSpecificDate |
xlNotSpecificDate |
xlBefore |
xlBeforeOrEqualTo |
xlAfter |
xlAfterOrEqualTo |
xlDateBetween |
xlDateNotBetween |
xlDateToday |
xlDateYesterday |
xlDateTomorrow |
xlDateThisWeek |
xlDateLastWeek |
xlDateNextWeek |
xlDateThisMonth |
xlDateLastMonth |
xlDateNextMonth |
xlDateThisQuarter |
xlDateLastQuarter |
xlDateNextQuarter |
xlDateThisYear |
xlDateLastYear |
xlDateNextYear |
xlYearToDate |
xlAllDatesInPeriodQuarter1 |
xlAllDatesInPeriodQuarter2 |
xlAllDatesInPeriodQuarter3 |
xlAllDatesInPeriodQuarter4 |
xlAllDatesInPeriodJanuary |
xlAllDatesInPeriodFebruary |
xlAllDatesInPeriodMarch |
xlAllDatesInPeriodApril |
xlAllDatesInPeriodMay |
xlAllDatesInPeriodJune |
xlAllDatesInPeriodJuly |
xlAllDatesInPeriodAugust |
xlAllDatesInPeriodSeptember |
xlAllDatesInPeriodOctober |
xlAllDatesInPeriodNovember |
xlAllDatesInPeriodDecember |