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