Skip to main content
Row

PivotFilter Members

Represents a filter applied to a PivotTable field.

Properties

Name Description
Description Gets or sets a brief description of the filter.
Field Gets the pivot field to which the current filter is applied.
FilterType Gets the type of the pivot filter.
MeasureField Gets the data field containing summary values being filtered by a value filter.
Name Gets or sets the name of the pivot filter.
SecondValue Gets the second filter criteria value.
Top10Type Gets or sets the type of the “Top 10” value filter.
UseWholeDay Gets or sets whether the date filter should use whole days in its filtering criteria.
Value Gets the first filter criteria value.

Methods

Name Description
Delete() Removes the current filter from the PivotFilterCollection collection.
See Also