## PivotAreaFilter class

Represents the filter of PivotArea for PivotTable .

## Constructors

| Name | Description |
| --- | --- |
| [PivotAreaFilter](#constructor) |  |

## Properties

| Name | Type | Description |
| --- | --- | --- |
| [FieldIndex](#fieldindex) | Number |  |
| [Selected](#selected) | boolean | Indicates whether this field has selection. Only works when the PivotTable is in Outline view. |

## Methods

| Name | Description |
| --- | --- |
| [isSubtotalSet](#issubtotalset) | Gets which subtotal is set for this filter. |
| [setSubtotals](#setsubtotals) | Subtotal for the filter. |

### PivotAreaFilter() {#constructor}

### PivotAreaFilter.FieldIndex property {#fieldindex}

**Type:** Number

### PivotAreaFilter.Selected property {#selected}

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

**Type:** boolean

### isSubtotalSet(subtotalType) {#issubtotalset}

Gets which subtotal is set for this filter.

| Parameter | Type | Description |
| --- | --- | --- |
| subtotalType | Number | A PivotFieldSubtotalType value. The subtotal function type. |

### setSubtotals(subtotalType, shown) {#setsubtotals}

Subtotal for the filter.

| Parameter | Type | Description |
| --- | --- | --- |
| subtotalType | Number | A PivotFieldSubtotalType value. The subtotal function. |
| shown | boolean | Indicates if showing this subtotal data. |