Class PivotAreaFilter

PivotAreaFilter class

Represents the filter of PivotArea for PivotTable.

public class PivotAreaFilter

Constructors

NameDescription
PivotAreaFilter()The default constructor.

Properties

NameDescription
Selected { get; set; }Indicates whether this field has selection. Only works when the PivotTable is in Outline view.

Methods

NameDescription
IsSubtotalSet(PivotFieldSubtotalType)Gets which subtotal is set for this filter.
SetSubtotals(PivotFieldSubtotalType, bool)Subtotal for the filter.

See Also