PivotAreaFilter
Contents
[
Hide
]PivotAreaFilter class
Represents the filter of PivotArea for PivotTable.
new PivotAreaFilter()
Methods
| Name | Description |
|---|---|
| getFieldIndex() | |
| getSelected() | Indicates whether this field has selection. Only works when the PivotTable is in Outline view. |
| isSubtotalSet(subtotalType) | Gets which subtotal is set for this filter. |
| setSelected() | Indicates whether this field has selection. Only works when the PivotTable is in Outline view. |
| setSubtotals(subtotalType, shown) | Subtotal for the filter. |
getFieldIndex()
getSelected()
Indicates whether this field has selection. Only works when the PivotTable is in Outline view.
isSubtotalSet(subtotalType)
Gets which subtotal is set for this filter.
| Parameter | Type | Description |
|---|---|---|
| subtotalType | Number | PivotFieldSubtotalType |
Returns: boolean — boolean
setSelected()
Indicates whether this field has selection. Only works when the PivotTable is in Outline view.
setSubtotals(subtotalType, shown)
Subtotal for the filter.
| Parameter | Type | Description |
|---|---|---|
| subtotalType | Number | PivotFieldSubtotalType |
| shown | boolean | Indicates if showing this subtotal data. |