PivotAreaFilter
Contents
[
Hide
]PivotAreaFilter class
Represents the filter of PivotArea for PivotTable .
Constructors
| Name | Description |
|---|---|
| PivotAreaFilter |
Properties
| Name | Type | Description |
|---|---|---|
| FieldIndex | int | |
| Selected | boolean | Indicates whether this field has selection. Only works when the PivotTable is in Outline view. |
Methods
| Name | Description |
|---|---|
| isSubtotalSet | Gets which subtotal is set for this filter. |
| setSubtotals | Subtotal for the filter. |
PivotAreaFilter()
PivotAreaFilter.FieldIndex property
Type: int
PivotAreaFilter.Selected property
Indicates whether this field has selection. Only works when the PivotTable is in Outline view.
Type: boolean
isSubtotalSet(subtotalType)
Gets which subtotal is set for this filter.
| Parameter | Type | Description |
|---|---|---|
| subtotalType | int | A PivotFieldSubtotalType value. The subtotal function type. |
setSubtotals(subtotalType, shown)
Subtotal for the filter.
| Parameter | Type | Description |
|---|---|---|
| subtotalType | int | A PivotFieldSubtotalType value. The subtotal function. |
| shown | boolean | Indicates if showing this subtotal data. |