Skip to main content
Row

PivotFilterCollection.Add Method

Name Parameters Description
Add(PivotField, PivotDataField, PivotFilterType, FilterValue, FilterValue) field, measureField, filterType, firstValue, secondValue Applies a value filter to the specified PivotTable field.
Add(PivotField, PivotDataField, PivotFilterType, FilterValue) field, measureField, filterType, value Applies a value filter to the specified PivotTable field.
Add(PivotField, PivotFilterType, FilterValue, FilterValue) field, filterType, firstValue, secondValue Applies a label or date filter to the specified PivotTable field.
Add(PivotField, PivotFilterType, FilterValue) field, filterType, value Applies a label or date filter to the specified PivotTable field.
Add(PivotField, PivotFilterType) field, filterType Applies a date filter to the specified PivotTable field.