PivotAreaFilter class

PivotAreaFilter class

Represents the filter of PivotArea for PivotTable.

The PivotAreaFilter type exposes the following members:

Constructors

ConstructorDescription
initConstructs a new instance of PivotAreaFilter

Properties

PropertyDescription
selectedIndicates whether this field has selection.
Only works when the PivotTable is in Outline view.

Methods

MethodDescription
is_subtotal_setGets which subtotal is set for this filter.
set_subtotalsSubtotal for the filter.

See Also