PivotField.ClearValueFilters Method
Calling this method deletes all value filters in the PivotFilters collection of the PivotField.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Sub ClearValueFilters
'Usage
Dim instance As PivotField
instance.ClearValueFilters()
void ClearValueFilters()
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 |