## GridPivotTable class

Represents a PivotTable report on a worksheet. The PivotTable object is a member of the !:PivotTables collection. The PivotTables collection contains all the PivotTable objects on a control.

```csharp
public class GridPivotTable
```

## Methods

| Name | Description |
| --- | --- |
| [AddFieldToArea](../../aspose.cells.griddesktop.data/gridpivottable/addfieldtoarea/#addfieldtoarea)(GridPivotFieldType, int) | Adds the field to the specific area. |
| [AddFieldToArea](../../aspose.cells.griddesktop.data/gridpivottable/addfieldtoarea/#addfieldtoarea_1)(GridPivotFieldType, string) | Adds the field to the specific area. |
| [CalculateData](../../aspose.cells.griddesktop.data/gridpivottable/calculatedata/)() | Calculates pivottable's data to cells. |
| [ClearAllFields](../../aspose.cells.griddesktop.data/gridpivottable/clearallfields/)() | clear all pivot fields. |
| [Fields](../../aspose.cells.griddesktop.data/gridpivottable/fields/#fields_1)(GridPivotFieldType) | Gets the specific fields by the field type. |
| [Fields](../../aspose.cells.griddesktop.data/gridpivottable/fields/#fields)(string) | Gets the specific field by the field name. |
| [RefreshData](../../aspose.cells.griddesktop.data/gridpivottable/refreshdata/)() | Refreshes pivottable's data and setting from it's data source. |

### See Also

* namespace [Aspose.Cells.GridDesktop.Data](../../aspose.cells.griddesktop.data/)
* assembly [Aspose.Cells.GridDesktop](../../)