Skip to main content
Row

PivotFilterCollection Members

A collection of filters applied to the PivotTable fields.

Properties

Name Description
Count Gets the number of elements contained in the ICollection. Inherited from ICollection.
IsSynchronized Gets a value indicating whether access to the ICollection is synchronized (thread safe). Inherited from ICollection.
SyncRoot Gets an object that can be used to synchronize access to the ICollection. Inherited from ICollection.

Methods

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