Skip to main content
Row

PivotFilterCollection Methods

A collection of filters applied to the PivotTable fields.
Name Description
Add(PivotField, PivotDataField, PivotFilterType, FilterValue, FilterValue) Applies a value filter to the specified PivotTable field.
Add(PivotField, PivotDataField, PivotFilterType, FilterValue) Applies a value filter to the specified PivotTable field.
Add(PivotField, PivotFilterType, FilterValue, FilterValue) Applies a label or date filter to the specified PivotTable field.
Add(PivotField, PivotFilterType, FilterValue) Applies a label or date filter to the specified PivotTable field.
Add(PivotField, PivotFilterType) Applies a date filter to the specified PivotTable field.
Clear() Removes all pivot filters from the collection.
Contains(PivotFilter) Determines whether the collection contains the specified filter.
CopyTo(Array, Int32) Copies the elements of the ICollection to an Array, starting at a particular Array index. Inherited from ICollection.
GetEnumerator() Returns an enumerator that iterates through the collection. Inherited from IEnumerable<T>.
IndexOf(PivotFilter) Returns the index of the specified item in the collection.
Remove(PivotFilter) Removes the specified filter from the collection.
RemoveAt(Int32) Removes a filter at the specified index from the collection.
See Also