PivotField.ClearValueFilters Method (Excel)
Calling this method deletes all value filters in the PivotFilters collection of the PivotField.
Version Information
Version Added: Excel 2007
Syntax
expression .ClearValueFilters
expression A variable that represents a PivotField object.
Remarks
The following table lists the different value filter types that will be deleted by this method.
xlTopCount |
xlBottomCount |
xlTopPercent |
xlBottomPercent |
xlTopSum |
xlBottomSum |
xlValueEquals |
xlValueDoesNotEqual |
xlValueIsGreaterThan |
xlValueIsGreaterThanOrEqualTo |
xlValueIsLessThan |
xlValueIsLessThanOrEqualTo |
xlValueIsBetween |
xlValueIsNotBetween |