## PivotArea class

Presents the selected area of the PivotTable.

```js
new PivotArea(table)
```

Presents the selected area of the PivotTable.

## Methods

| Name | Description |
| --- | --- |
| [getAxisType()](#getaxistype) | Gets and sets the region of the PivotTable to which this rule applies. The value of the property is PivotFieldType integ |
| [getCellAreas()](#getcellareas) |  |
| [getFilters()](#getfilters) | Gets all filters for this PivotArea. |
| [getOnlyData()](#getonlydata) | Indicates whether only the data values (in the data area of the view) for an item selection are selected and does not in |
| [getOnlyLabel()](#getonlylabel) | Indicates whether only the data labels for an item selection are selected. |
| [getRuleType()](#getruletype) | Gets and sets the type of selection rule. The value of the property is PivotAreaType integer constant. |
| [isColumnGrandIncluded()](#iscolumngrandincluded) | Indicates whether the column grand total is included. |
| [isOutline()](#isoutline) | Indicates whether the rule refers to an area that is in outline mode. |
| [isRowGrandIncluded()](#isrowgrandincluded) | Indicates whether the row grand total is included. |
| [select(axisType, fieldPosition, selectionType)](#select) | Select the area with filters. |
| [selectField()](#selectfield) |  |
| [selectField()](#selectfield-1) |  |
| [setAxisType()](#setaxistype) | Gets and sets the region of the PivotTable to which this rule applies. The value of the property is PivotFieldType integ |
| [setColumnGrandIncluded()](#setcolumngrandincluded) | Indicates whether the column grand total is included. |
| [setOnlyData()](#setonlydata) | Indicates whether only the data values (in the data area of the view) for an item selection are selected and does not in |
| [setOnlyLabel()](#setonlylabel) | Indicates whether only the data labels for an item selection are selected. |
| [setOutline()](#setoutline) | Indicates whether the rule refers to an area that is in outline mode. |
| [setRowGrandIncluded()](#setrowgrandincluded) | Indicates whether the row grand total is included. |
| [setRuleType()](#setruletype) | Gets and sets the type of selection rule. The value of the property is PivotAreaType integer constant. |

### getAxisType() {#getaxistype}

Gets and sets the region of the PivotTable to which this rule applies. The value of the property is PivotFieldType integer constant.

### getCellAreas() {#getcellareas}

### getFilters() {#getfilters}

Gets all filters for this PivotArea.

### getOnlyData() {#getonlydata}

Indicates whether only the data values (in the data area of the view) for an item selection are selected and does not include the item labels.

### getOnlyLabel() {#getonlylabel}

Indicates whether only the data labels for an item selection are selected.

### getRuleType() {#getruletype}

Gets and sets the type of selection rule. The value of the property is PivotAreaType integer constant.

### isColumnGrandIncluded() {#iscolumngrandincluded}

Indicates whether the column grand total is included.

### isOutline() {#isoutline}

Indicates whether the rule refers to an area that is in outline mode.

### isRowGrandIncluded() {#isrowgrandincluded}

Indicates whether the row grand total is included.

### select(axisType, fieldPosition, selectionType) {#select}

Select the area with filters.

| Parameter | Type | Description |
| --- | --- | --- |
| axisType | Number | PivotFieldType |
| fieldPosition | Number | Position of the field within the axis to which this rule applies. |
| selectionType | Number | PivotTableSelectionType |

### selectField() {#selectfield}

### selectField() {#selectfield-1}

### setAxisType() {#setaxistype}

Gets and sets the region of the PivotTable to which this rule applies. The value of the property is PivotFieldType integer constant.

### setColumnGrandIncluded() {#setcolumngrandincluded}

Indicates whether the column grand total is included.

### setOnlyData() {#setonlydata}

Indicates whether only the data values (in the data area of the view) for an item selection are selected and does not include the item labels.

### setOnlyLabel() {#setonlylabel}

Indicates whether only the data labels for an item selection are selected.

### setOutline() {#setoutline}

Indicates whether the rule refers to an area that is in outline mode.

### setRowGrandIncluded() {#setrowgrandincluded}

Indicates whether the row grand total is included.

### setRuleType() {#setruletype}

Gets and sets the type of selection rule. The value of the property is PivotAreaType integer constant.