## PivotTable class


Summary description for [PivotTable](./).

```cpp
class PivotTable
```

## Methods

| Method | Description |
| --- | --- |
| [AddCalculatedField(const U16String\& name, const U16String\& formula, bool dragToDataArea)](./addcalculatedfield/) | Adds a calculated field to pivot field. |
| [AddCalculatedField(const char16_t* name, const char16_t* formula, bool dragToDataArea)](./addcalculatedfield/) | Adds a calculated field to pivot field. |
| [AddCalculatedField(const U16String\& name, const U16String\& formula)](./addcalculatedfield/) | Adds a calculated field to pivot field and drag it to data area. |
| [AddCalculatedField(const char16_t* name, const char16_t* formula)](./addcalculatedfield/) | Adds a calculated field to pivot field and drag it to data area. |
| [AddFieldToArea(PivotFieldType fieldType, const U16String\& fieldName)](./addfieldtoarea/) | Adds the field to the specific area. |
| [AddFieldToArea(PivotFieldType fieldType, const char16_t* fieldName)](./addfieldtoarea/) | Adds the field to the specific area. |
| [AddFieldToArea(PivotFieldType fieldType, int32_t baseFieldIndex)](./addfieldtoarea/) | Adds the field to the specific area. |
| [AddFieldToArea(PivotFieldType fieldType, const PivotField\& pivotField)](./addfieldtoarea/) | Adds the field to the specific area. |
| [CalculateData()](./calculatedata/) | Calculates data of pivottable to cells. |
| [CalculateData(const PivotTableCalculateOption\& option)](./calculatedata/) | Calculates pivot table with options. |
| [CalculateRange()](./calculaterange/) | Calculates pivottable's range. |
| [ChangeDataSource(const Vector \<U16String\>\& source)](./changedatasource/) | Change data source of the pivot table. |
| [ClearAll()](./clearall/) | Remove all fields from regions. |
| [ClearData()](./cleardata/) | Clear data and formatting of [PivotTable](./) view. |
| [ClearFilters()](./clearfilters/) | Clears all filters of this pivot table. |
| [CopyStyle(const PivotTable\& pivotTable)](./copystyle/) | Copies named style from another pivot table. |
| [Dispose()](./dispose/) | Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. |
| [ExportViewToJson(const PivotViewToJsonOptions\& options)](./exportviewtojson/) | Exports pivot view as JSON. |
| [Format(const PivotArea\& pivotArea, const Style\& style)](./format/) | Formats selected area of the [PivotTable](./). |
| [Format(const CellArea\& ca, const Style\& style)](./format/) | Formats selected area of the [PivotTable](./). |
| [Format(int32_t row, int32_t column, const Style\& style)](./format/) | Formats the cell in the pivottable area. |
| [FormatAll(const Style\& style)](./formatall/) | Format all the cell in the pivottable area. |
| [FormatRow(int32_t row, const Style\& style)](./formatrow/) | Format the row data in the pivottable area. |
| [GetAllowMultipleFiltersPerField()](./getallowmultiplefiltersperfield/) | Specifies a boolean value that indicates whether the fields of a [PivotTable](./) can have multiple filters set on them. |
| [GetAltTextDescription()](./getalttextdescription/) | Gets the description of the alt text. |
| [GetAltTextTitle()](./getalttexttitle/) | Gets and sets the title of the alter text. |
| [GetAutofitColumnWidthOnUpdate()](./getautofitcolumnwidthonupdate/) | Indicates whether to autofit column width on update. |
| [GetAutoFormatType()](./getautoformattype/) | Gets and sets the auto format type of [PivotTable](./). |
| [GetBaseFields()](./getbasefields/) | Returns all base pivot fields in the [PivotTable](./). |
| [GetButtonArea(PivotFieldType axisType)](./getbuttonarea/) | Gets the area contains field button. |
| [GetCellByDisplayName(const U16String\& displayName)](./getcellbydisplayname/) | Gets the [Cell](../../aspose.cells/cell/) object by the display name of [PivotField](../pivotfield/). |
| [GetCellByDisplayName(const char16_t* displayName)](./getcellbydisplayname/) | Gets the [Cell](../../aspose.cells/cell/) object by the display name of [PivotField](../pivotfield/). |
| [GetChildren()](./getchildren/) |  **(Deprecated)** Gets the Children [Pivot](../)[Tables](../../aspose.cells.tables/) which use this [PivotTable](./) data as data source. |
| [GetColumnFields()](./getcolumnfields/) | Returns a PivotFields object that are currently shown as column fields. |
| [GetColumnGrand()](./getcolumngrand/) |  **(Deprecated)** Indicates whether the [PivotTable](./) report shows grand totals for columns. |
| [GetColumnHeaderCaption()](./getcolumnheadercaption/) | Gets and sets the custom Caption of the [Column](../../aspose.cells/column/) Header of the [PivotTable](./). |
| [GetColumnRange()](./getcolumnrange/) | Returns a [CellArea](../../aspose.cells/cellarea/) object that represents the range that contains the column area in the [PivotTable](./) report. Read-only. |
| [GetConditionalFormats()](./getconditionalformats/) | Gets the conditional formats of the pivot table. |
| [GetCustomListSort()](./getcustomlistsort/) | Indicates whether consider built-in custom list when sort data. |
| [GetDataBodyRange()](./getdatabodyrange/) | Returns a [CellArea](../../aspose.cells/cellarea/) object that represents the range that contains the data area in the list between the header row and the insert row. Read-only. |
| [GetDataField()](./getdatafield/) |  **(Deprecated)** Gets a [PivotField](../pivotfield/) object that represents all the data fields in a [PivotTable](./). Read-only. It would only be created when there are two or more data fields in the Data region. Defaultly it is in row region. You can drag it to the row/column region with [PivotTable.AddFieldToArea()](./addfieldtoarea/) method . |
| [GetDataFieldHeaderName()](./getdatafieldheadername/) | Gets and sets the name of the value area field header in the [PivotTable](./). |
| [GetDataFields()](./getdatafields/) | Gets a [PivotField](../pivotfield/) object that represents all the data fields in a [PivotTable](./). Read-only.It would be init only when there are two or more data fields in the DataPiovtFiels. It only use to add DataPivotField to the [PivotTable](./) row/column area . Default is in row area. |
| [GetDataSource()](./getdatasource/) | Gets and sets the data source of the pivot table. |
| [GetDependentPivotTables()](./getdependentpivottables/) | Gets all [PivotTable](./)s that use this [PivotTable](./) as their data source. |
| [GetDisplayErrorString()](./getdisplayerrorstring/) | Indicates whether the [PivotTable](./) report displays a custom string in cells that contain errors. |
| [GetDisplayImmediateItems()](./getdisplayimmediateitems/) | Indicates whether items in the row and column areas are visible when the data area of the [PivotTable](./) is empty. The default value is true. |
| [GetDisplayNullString()](./getdisplaynullstring/) | Indicates whether the [PivotTable](./) report displays a custom string if the value is null. |
| [GetEnableDataValueEditing()](./getenabledatavalueediting/) | Specifies a boolean value that indicates whether the user is allowed to edit the cells in the data area of the pivottable. Enable cell editing in the values area. |
| [GetEnableDrilldown()](./getenabledrilldown/) | Indicates whether drilldown is enabled. |
| [GetEnableFieldDialog()](./getenablefielddialog/) | Indicates whether the [PivotTable](./) Field dialog box is available when the user double-clicks the [PivotTable](./) field. |
| [GetEnableFieldList()](./getenablefieldlist/) | Indicates whether the field list for the [PivotTable](./) is available on the view of Excel. |
| [GetEnableWizard()](./getenablewizard/) | Indicates whether the [PivotTable](./) Wizard is available. |
| [GetErrorString()](./geterrorstring/) | Gets the string displayed in cells that contain errors when the DisplayErrorString property is true.The default value is an empty string. |
| [GetExternalConnectionDataSource()](./getexternalconnectiondatasource/) |  **(Deprecated)** Gets the external connection data source. |
| [GetFieldListSortAscending()](./getfieldlistsortascending/) | Indicates whether fields in the [PivotTable](./) are sorted in non-default order in the field list. |
| [GetFields(PivotFieldType fieldType)](./getfields/) | Gets the specific pivot field list by the region. |
| [GetFilterArea()](./getfilterarea/) | Gets the area of filter region. |
| [GetGrandTotalName()](./getgrandtotalname/) | Returns the label that is displayed in the grand total column or row heading. The default value is the string "Grand Total". |
| [GetHorizontalPageBreaks()](./gethorizontalpagebreaks/) | Gets horizontal page breaks of this pivot table. |
| [GetIndent()](./getindent/) | Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form. |
| [GetItemPrintTitles()](./getitemprinttitles/) |  **(Deprecated)** Indicates whether [PivotItem](../pivotitem/) names should be repeated at the top of each printed page. |
| [GetManualUpdate()](./getmanualupdate/) | Indicates whether the [PivotTable](./) report is recalculated only at the user's request. |
| [GetMergeLabels()](./getmergelabels/) | Indicates whether row or column titles that span multiple cells should be merged into a single cell. |
| [GetMissingItemsLimit()](./getmissingitemslimit/) |  **(Deprecated)** Specifies a boolean value that indicates whether the fields of a [PivotTable](./) can have multiple filters set on them. |
| [GetName()](./getname/) | Gets the name of the [PivotTable](./). |
| [GetNamesOfSourceDataConnections()](./getnamesofsourcedataconnections/) | Gets the names of external source data connections. |
| [GetNullString()](./getnullstring/) | Gets the string displayed in cells that contain null values when the DisplayNullString property is true.The default value is an empty string. |
| [GetPageFieldOrder()](./getpagefieldorder/) | Gets and sets the order in which page fields are added to the [PivotTable](./) report's layout. |
| [GetPageFields()](./getpagefields/) | Returns a PivotFields object that are currently shown as page fields. |
| [GetPageFieldWrapCount()](./getpagefieldwrapcount/) | Gets the number of page fields in each column or row in the [PivotTable](./) report. |
| [GetPivotCache()](./getpivotcache/) | Gets the data source. |
| [GetPivotFilters()](./getpivotfilters/) | Returns all filters of pivot fields in the pivot table. |
| [GetPivotFormatConditions()](./getpivotformatconditions/) |  **(Deprecated)** Gets the Format Conditions of the pivot table. |
| [GetPivotFormats()](./getpivotformats/) | Gets all formats applied to [PivotTable](./). |
| [GetPivotTableStyle()](./getpivottablestyle/) | Gets TableStyle settings of this pivot table. |
| [GetPivotTableStyleName()](./getpivottablestylename/) | Gets or sets style name of the pivot table. |
| [GetPivotTableStyleType()](./getpivottablestyletype/) | Gets and sets the built-in pivot table style. |
| [GetPivotTablesWithSamePivotCache()](./getpivottableswithsamepivotcache/) | Gets all pivot tables with same pivot cache. |
| [GetPreserveCellFormattingOnUpdate()](./getpreservecellformattingonupdate/) | Indicates whether to preserve cell formatting ([PivotTableFormat](../pivottableformat/)) when the pivot table is refreshed or recalculated. |
| [GetPreserveFormatting()](./getpreserveformatting/) |  **(Deprecated)** Indicates whether cell formatting ([PivotTableFormat](../pivottableformat/)) is preserved when the [PivotTable](./) is refreshed or recalculated. |
| [GetPrintDrill()](./getprintdrill/) | Specifies a boolean value that indicates whether drill indicators should be printed. Print expand/collapse buttons when displayed on pivottable. |
| [GetPrintTitles()](./getprinttitles/) | Indicates whether the print titles for the worksheet are set based on the [PivotTable](./) report. The default value is false. |
| [GetRefreshDataOnOpeningFile()](./getrefreshdataonopeningfile/) | Indicates whether Refresh Data when Opening File. |
| [GetRefreshDate()](./getrefreshdate/) | Gets the last date time when the [PivotTable](./) was refreshed. |
| [GetRefreshedByWho()](./getrefreshedbywho/) | Gets the name of the last user who refreshed this [PivotTable](./). |
| [GetRepeatItemsOnEachPrintedPage()](./getrepeatitemsoneachprintedpage/) | Indicates whether captions of pivot item on the row area are repeated on each printed page for pivot fields in tabular form. |
| [GetRowFields()](./getrowfields/) | Returns a PivotFields object that are currently shown as row fields. |
| [GetRowGrand()](./getrowgrand/) |  **(Deprecated)** Indicates whether to show grand totals for rows of this pivot table. |
| [GetRowHeaderCaption()](./getrowheadercaption/) | Gets and sets custom caption of the [Row](../../aspose.cells/row/) Header in this [PivotTable](./). |
| [GetRowRange()](./getrowrange/) | Returns a [CellArea](../../aspose.cells/cellarea/) object that represents the range that contains the row area in the [PivotTable](./) report. Read-only. |
| [GetSaveData()](./getsavedata/) | Indicates whether data for the [PivotTable](./) report is saved with the workbook. |
| [GetShowColumnGrandTotals()](./getshowcolumngrandtotals/) | Indicates whether to show grand totals for columns of this pivot table. |
| [GetShowDataTips()](./getshowdatatips/) | Indicates whether tooltips should be displayed for [PivotTable](./) data cells. |
| [GetShowDrill()](./getshowdrill/) | Gets and sets whether showing expand/collapse buttons. |
| [GetShowEmptyCol()](./getshowemptycol/) | Indicates whether to include empty columns in the table. |
| [GetShowEmptyRow()](./getshowemptyrow/) | Indicates whether to include empty rows in the table. |
| [GetShowHeaders()](./getshowheaders/) | Whether to show data field captions and pivot field captions on the row axis and the column axis in the [PivotTable](./) view. |
| [GetShowMemberPropertyTips()](./getshowmemberpropertytips/) | Specifies a boolean value that indicates whether member property information should be omitted from [PivotTable](./) tooltips. |
| [GetShowPivotStyleColumnHeader()](./getshowpivotstylecolumnheader/) | Indicates whether the column header in the pivot table should have the style applied. |
| [GetShowPivotStyleColumnStripes()](./getshowpivotstylecolumnstripes/) | Indicates whether stripe formatting is applied for column. |
| [GetShowPivotStyleLastColumn()](./getshowpivotstylelastcolumn/) | Indicates whether the column formatting is applied. |
| [GetShowPivotStyleRowHeader()](./getshowpivotstylerowheader/) | Indicates whether the row header in the pivot table should have the style applied. |
| [GetShowPivotStyleRowStripes()](./getshowpivotstylerowstripes/) | Indicates whether row stripe formatting is applied. |
| [GetShowRowGrandTotals()](./getshowrowgrandtotals/) | Indicates whether to show grand totals for rows of the pivot table. |
| [GetShowRowHeaderCaption()](./getshowrowheadercaption/) |  **(Deprecated)** Indicates whether row header caption is shown in the [PivotTable](./) report Indicates whether Display field captions and filter drop downs. |
| [GetShowValuesRow()](./getshowvaluesrow/) | Indicates whether showing values row. |
| [GetSource()](./getsource/) | Get the data source of this pivot table. |
| [GetSource(bool isOriginal)](./getsource/) | Get the data source of this pivot table. |
| [GetSourceDataConnections()](./getsourcedataconnections/) | Gets the external connection data sources. |
| [GetSourceType()](./getsourcetype/) | Gets the data source type of the pivot table. |
| [GetSubtotalHiddenPageItems()](./getsubtotalhiddenpageitems/) | Indicates whether hidden page field items in the [PivotTable](./) report are included in row and column subtotals, block totals, and grand totals. The default value is False. |
| [GetTableRange1()](./gettablerange1/) | Returns a [CellArea](../../aspose.cells/cellarea/) object that represents the range containing the entire [PivotTable](./) report, but doesn't include page fields. Read-only. |
| [GetTableRange2()](./gettablerange2/) | Returns a [CellArea](../../aspose.cells/cellarea/) object that represents the range containing the entire [PivotTable](./) report, includes page fields. Read-only. |
| [GetTag()](./gettag/) | Gets and sets a user-defined string that is associated with this [PivotTable](./) view. |
| [GetTopRightArea()](./gettoprightarea/) | Represents the blank area at the top-right of the [PivotTable](./) (top-left for RTL sheets). |
| [GetValuesField()](./getvaluesfield/) | Gets a [PivotField](../pivotfield/) object that represents all the data fields in a [PivotTable](./). Read-only. It would only be created when there are two or more data fields in the Data region. Defaultly it is in row region. You can drag it to the row/column region with [PivotTable.AddFieldToArea()](./addfieldtoarea/) method . |
| [IsAutoFormat()](./isautoformat/) | Indicates whether the [PivotTable](./) report is automatically formatted. Checkbox "autoformat table " which is in pivottable option for Excel 2003. |
| [IsExcel2003Compatible()](./isexcel2003compatible/) | Specifies whether the [PivotTable](./) is compatible for Excel2003 when refreshing [PivotTable](./), if true, a string must be less than or equal to 255 characters, so if the string is greater than 255 characters, it will be truncated. if false, a string will not have the aforementioned restriction. The default value is true. |
| [IsGridDropZones()](./isgriddropzones/) | Indicates whether the [PivotTable](./) report displays classic pivottable layout. (enables dragging fields in the grid) |
| [IsMultipleFieldFilters()](./ismultiplefieldfilters/) |  **(Deprecated)** Specifies a boolean value that indicates whether the fields of a [PivotTable](./) can have multiple filters set on them. |
| [IsNull()](./isnull/) const | Checks whether the implementation object is nullptr. |
| [IsSelected()](./isselected/) | Indicates whether this [PivotTable](./) is selected. |
| [Move(int32_t row, int32_t column)](./move/) |  **(Deprecated)** Moves the [PivotTable](./) to a different location in the worksheet. |
| [Move(const U16String\& destCellName)](./move/) |  **(Deprecated)** Moves the [PivotTable](./) to a different location in the worksheet. |
| [Move(const char16_t* destCellName)](./move/) |  **(Deprecated)** Moves the [PivotTable](./) to a different location in the worksheet. |
| [MoveTo(int32_t row, int32_t column)](./moveto/) | Moves the [PivotTable](./) to a different location in the worksheet. |
| [MoveTo(int32_t sheetIndex, int32_t row, int32_t column)](./moveto/) | Moves the [PivotTable](./) to a different location in the worksheet. |
| [MoveTo(const U16String\& destCellName)](./moveto/) | Moves the [PivotTable](./) to a different location in the worksheet. |
| [MoveTo(const char16_t* destCellName)](./moveto/) | Moves the [PivotTable](./) to a different location in the worksheet. |
| explicit [operator bool()](./operator_bool/) const | operator bool() |
| [operator=(const PivotTable\& src)](./operator_asm/) | operator= |
| [PivotTable(PivotTable_Impl* impl)](./pivottable/) | Constructs from an implementation object. |
| [PivotTable(const PivotTable\& src)](./pivottable/) | Copy constructor. |
| [Refresh(const PivotTableRefreshOption\& option)](./refresh/) | Refresh [PivotCache](../pivotcache/) from data source and calculate data and style for pivot view. |
| [RefreshData()](./refreshdata/) |  **(Deprecated)** Refreshes data from it's data source to pivot cache. |
| [RefreshData(const PivotTableRefreshOption\& option)](./refreshdata/) |  **(Deprecated)** Refreshes pivottable's data and setting from it's data source with options. |
| [RemoveField(PivotFieldType fieldType, const U16String\& fieldName)](./removefield/) | Removes a field from specific field area. |
| [RemoveField(PivotFieldType fieldType, const char16_t* fieldName)](./removefield/) | Removes a field from specific field area. |
| [RemoveField(PivotFieldType fieldType, int32_t baseFieldIndex)](./removefield/) | Removes a field from specific pivot region. |
| [RemoveField(PivotFieldType fieldType, const PivotField\& pivotField)](./removefield/) | Remove field from specific field area. |
| [SelectArea(const CellArea\& ca)](./selectarea/) | Select an area of pivot table view. |
| [SetAllowMultipleFiltersPerField(bool value)](./setallowmultiplefiltersperfield/) | Specifies a boolean value that indicates whether the fields of a [PivotTable](./) can have multiple filters set on them. |
| [SetAltTextDescription(const U16String\& value)](./setalttextdescription/) | Gets the description of the alt text. |
| [SetAltTextDescription(const char16_t* value)](./setalttextdescription/) | Gets the description of the alt text. |
| [SetAltTextTitle(const U16String\& value)](./setalttexttitle/) | Gets and sets the title of the alter text. |
| [SetAltTextTitle(const char16_t* value)](./setalttexttitle/) | Gets and sets the title of the alter text. |
| [SetAutofitColumnWidthOnUpdate(bool value)](./setautofitcolumnwidthonupdate/) | Indicates whether to autofit column width on update. |
| [SetAutoFormatType(PivotTableAutoFormatType value)](./setautoformattype/) | Gets and sets the auto format type of [PivotTable](./). |
| [SetColumnGrand(bool value)](./setcolumngrand/) |  **(Deprecated)** Indicates whether the [PivotTable](./) report shows grand totals for columns. |
| [SetColumnHeaderCaption(const U16String\& value)](./setcolumnheadercaption/) | Gets and sets the custom Caption of the [Column](../../aspose.cells/column/) Header of the [PivotTable](./). |
| [SetColumnHeaderCaption(const char16_t* value)](./setcolumnheadercaption/) | Gets and sets the custom Caption of the [Column](../../aspose.cells/column/) Header of the [PivotTable](./). |
| [SetCustomListSort(bool value)](./setcustomlistsort/) | Indicates whether consider built-in custom list when sort data. |
| [SetDataFieldHeaderName(const U16String\& value)](./setdatafieldheadername/) | Gets and sets the name of the value area field header in the [PivotTable](./). |
| [SetDataFieldHeaderName(const char16_t* value)](./setdatafieldheadername/) | Gets and sets the name of the value area field header in the [PivotTable](./). |
| [SetDataSource(const Vector \<U16String\>\& value)](./setdatasource/) | Gets and sets the data source of the pivot table. |
| [SetDisplayErrorString(bool value)](./setdisplayerrorstring/) | Indicates whether the [PivotTable](./) report displays a custom string in cells that contain errors. |
| [SetDisplayImmediateItems(bool value)](./setdisplayimmediateitems/) | Indicates whether items in the row and column areas are visible when the data area of the [PivotTable](./) is empty. The default value is true. |
| [SetDisplayNullString(bool value)](./setdisplaynullstring/) | Indicates whether the [PivotTable](./) report displays a custom string if the value is null. |
| [SetEnableDataValueEditing(bool value)](./setenabledatavalueediting/) | Specifies a boolean value that indicates whether the user is allowed to edit the cells in the data area of the pivottable. Enable cell editing in the values area. |
| [SetEnableDrilldown(bool value)](./setenabledrilldown/) | Indicates whether drilldown is enabled. |
| [SetEnableFieldDialog(bool value)](./setenablefielddialog/) | Indicates whether the [PivotTable](./) Field dialog box is available when the user double-clicks the [PivotTable](./) field. |
| [SetEnableFieldList(bool value)](./setenablefieldlist/) | Indicates whether the field list for the [PivotTable](./) is available on the view of Excel. |
| [SetEnableWizard(bool value)](./setenablewizard/) | Indicates whether the [PivotTable](./) Wizard is available. |
| [SetErrorString(const U16String\& value)](./seterrorstring/) | Gets the string displayed in cells that contain errors when the DisplayErrorString property is true.The default value is an empty string. |
| [SetErrorString(const char16_t* value)](./seterrorstring/) | Gets the string displayed in cells that contain errors when the DisplayErrorString property is true.The default value is an empty string. |
| [SetFieldListSortAscending(bool value)](./setfieldlistsortascending/) | Indicates whether fields in the [PivotTable](./) are sorted in non-default order in the field list. |
| [SetGrandTotalName(const U16String\& value)](./setgrandtotalname/) | Returns the label that is displayed in the grand total column or row heading. The default value is the string "Grand Total". |
| [SetGrandTotalName(const char16_t* value)](./setgrandtotalname/) | Returns the label that is displayed in the grand total column or row heading. The default value is the string "Grand Total". |
| [SetIndent(int32_t value)](./setindent/) | Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form. |
| [SetIsAutoFormat(bool value)](./setisautoformat/) | Indicates whether the [PivotTable](./) report is automatically formatted. Checkbox "autoformat table " which is in pivottable option for Excel 2003. |
| [SetIsExcel2003Compatible(bool value)](./setisexcel2003compatible/) | Specifies whether the [PivotTable](./) is compatible for Excel2003 when refreshing [PivotTable](./), if true, a string must be less than or equal to 255 characters, so if the string is greater than 255 characters, it will be truncated. if false, a string will not have the aforementioned restriction. The default value is true. |
| [SetIsGridDropZones(bool value)](./setisgriddropzones/) | Indicates whether the [PivotTable](./) report displays classic pivottable layout. (enables dragging fields in the grid) |
| [SetIsMultipleFieldFilters(bool value)](./setismultiplefieldfilters/) |  **(Deprecated)** Specifies a boolean value that indicates whether the fields of a [PivotTable](./) can have multiple filters set on them. |
| [SetIsSelected(bool value)](./setisselected/) | Indicates whether this [PivotTable](./) is selected. |
| [SetItemPrintTitles(bool value)](./setitemprinttitles/) |  **(Deprecated)** Indicates whether [PivotItem](../pivotitem/) names should be repeated at the top of each printed page. |
| [SetManualUpdate(bool value)](./setmanualupdate/) | Indicates whether the [PivotTable](./) report is recalculated only at the user's request. |
| [SetMergeLabels(bool value)](./setmergelabels/) | Indicates whether row or column titles that span multiple cells should be merged into a single cell. |
| [SetMissingItemsLimit(PivotMissingItemLimitType value)](./setmissingitemslimit/) |  **(Deprecated)** Specifies a boolean value that indicates whether the fields of a [PivotTable](./) can have multiple filters set on them. |
| [SetName(const U16String\& value)](./setname/) | Gets the name of the [PivotTable](./). |
| [SetName(const char16_t* value)](./setname/) | Gets the name of the [PivotTable](./). |
| [SetNullString(const U16String\& value)](./setnullstring/) | Gets the string displayed in cells that contain null values when the DisplayNullString property is true.The default value is an empty string. |
| [SetNullString(const char16_t* value)](./setnullstring/) | Gets the string displayed in cells that contain null values when the DisplayNullString property is true.The default value is an empty string. |
| [SetPageFieldOrder(PrintOrderType value)](./setpagefieldorder/) | Gets and sets the order in which page fields are added to the [PivotTable](./) report's layout. |
| [SetPageFieldWrapCount(int32_t value)](./setpagefieldwrapcount/) | Gets the number of page fields in each column or row in the [PivotTable](./) report. |
| [SetPivotTableStyle(const TableStyle\& value)](./setpivottablestyle/) | Gets TableStyle settings of this pivot table. |
| [SetPivotTableStyleName(const U16String\& value)](./setpivottablestylename/) | Gets or sets style name of the pivot table. |
| [SetPivotTableStyleName(const char16_t* value)](./setpivottablestylename/) | Gets or sets style name of the pivot table. |
| [SetPivotTableStyleType(PivotTableStyleType value)](./setpivottablestyletype/) | Gets and sets the built-in pivot table style. |
| [SetPreserveCellFormattingOnUpdate(bool value)](./setpreservecellformattingonupdate/) | Indicates whether to preserve cell formatting ([PivotTableFormat](../pivottableformat/)) when the pivot table is refreshed or recalculated. |
| [SetPreserveFormatting(bool value)](./setpreserveformatting/) |  **(Deprecated)** Indicates whether cell formatting ([PivotTableFormat](../pivottableformat/)) is preserved when the [PivotTable](./) is refreshed or recalculated. |
| [SetPrintDrill(bool value)](./setprintdrill/) | Specifies a boolean value that indicates whether drill indicators should be printed. Print expand/collapse buttons when displayed on pivottable. |
| [SetPrintTitles(bool value)](./setprinttitles/) | Indicates whether the print titles for the worksheet are set based on the [PivotTable](./) report. The default value is false. |
| [SetRefreshDataOnOpeningFile(bool value)](./setrefreshdataonopeningfile/) | Indicates whether Refresh Data when Opening File. |
| [SetRepeatItemsOnEachPrintedPage(bool value)](./setrepeatitemsoneachprintedpage/) | Indicates whether captions of pivot item on the row area are repeated on each printed page for pivot fields in tabular form. |
| [SetRowGrand(bool value)](./setrowgrand/) |  **(Deprecated)** Indicates whether to show grand totals for rows of this pivot table. |
| [SetRowHeaderCaption(const U16String\& value)](./setrowheadercaption/) | Gets and sets custom caption of the [Row](../../aspose.cells/row/) Header in this [PivotTable](./). |
| [SetRowHeaderCaption(const char16_t* value)](./setrowheadercaption/) | Gets and sets custom caption of the [Row](../../aspose.cells/row/) Header in this [PivotTable](./). |
| [SetSaveData(bool value)](./setsavedata/) | Indicates whether data for the [PivotTable](./) report is saved with the workbook. |
| [SetShowColumnGrandTotals(bool value)](./setshowcolumngrandtotals/) | Indicates whether to show grand totals for columns of this pivot table. |
| [SetShowDataTips(bool value)](./setshowdatatips/) | Indicates whether tooltips should be displayed for [PivotTable](./) data cells. |
| [SetShowDrill(bool value)](./setshowdrill/) | Gets and sets whether showing expand/collapse buttons. |
| [SetShowEmptyCol(bool value)](./setshowemptycol/) | Indicates whether to include empty columns in the table. |
| [SetShowEmptyRow(bool value)](./setshowemptyrow/) | Indicates whether to include empty rows in the table. |
| [SetShowHeaders(bool value)](./setshowheaders/) | Whether to show data field captions and pivot field captions on the row axis and the column axis in the [PivotTable](./) view. |
| [SetShowMemberPropertyTips(bool value)](./setshowmemberpropertytips/) | Specifies a boolean value that indicates whether member property information should be omitted from [PivotTable](./) tooltips. |
| [SetShowPivotStyleColumnHeader(bool value)](./setshowpivotstylecolumnheader/) | Indicates whether the column header in the pivot table should have the style applied. |
| [SetShowPivotStyleColumnStripes(bool value)](./setshowpivotstylecolumnstripes/) | Indicates whether stripe formatting is applied for column. |
| [SetShowPivotStyleLastColumn(bool value)](./setshowpivotstylelastcolumn/) | Indicates whether the column formatting is applied. |
| [SetShowPivotStyleRowHeader(bool value)](./setshowpivotstylerowheader/) | Indicates whether the row header in the pivot table should have the style applied. |
| [SetShowPivotStyleRowStripes(bool value)](./setshowpivotstylerowstripes/) | Indicates whether row stripe formatting is applied. |
| [SetShowRowGrandTotals(bool value)](./setshowrowgrandtotals/) | Indicates whether to show grand totals for rows of the pivot table. |
| [SetShowRowHeaderCaption(bool value)](./setshowrowheadercaption/) |  **(Deprecated)** Indicates whether row header caption is shown in the [PivotTable](./) report Indicates whether Display field captions and filter drop downs. |
| [SetShowValuesRow(bool value)](./setshowvaluesrow/) | Indicates whether showing values row. |
| [SetSubtotalHiddenPageItems(bool value)](./setsubtotalhiddenpageitems/) | Indicates whether hidden page field items in the [PivotTable](./) report are included in row and column subtotals, block totals, and grand totals. The default value is False. |
| [SetTag(const U16String\& value)](./settag/) | Gets and sets a user-defined string that is associated with this [PivotTable](./) view. |
| [SetTag(const char16_t* value)](./settag/) | Gets and sets a user-defined string that is associated with this [PivotTable](./) view. |
| [ShowDetail(int32_t rowOffset, int32_t columnOffset, bool newSheet, int32_t destRow, int32_t destColumn)](./showdetail/) | Show the detail of one item in the data region to a new Table. |
| [ShowInCompactForm()](./showincompactform/) | Layouts the [PivotTable](./) view in compact form. |
| [ShowInOutlineForm()](./showinoutlineform/) | Layouts the [PivotTable](./) in outline form. |
| [ShowInTabularForm()](./showintabularform/) | Layouts the [PivotTable](./) in tabular form. |
| [ShowReportFilterPage(const PivotField\& pageField)](./showreportfilterpage/) | Show all the report filter pages according to [PivotField](../pivotfield/), the [PivotField](../pivotfield/) must be located in the PageFields. |
| [ShowReportFilterPageByIndex(int32_t posIndex)](./showreportfilterpagebyindex/) | Show all the report filter pages according to the position index in the PageFields. |
| [ShowReportFilterPageByName(const U16String\& fieldName)](./showreportfilterpagebyname/) | Show all the report filter pages according to [PivotField](../pivotfield/)'s name, the [PivotField](../pivotfield/) must be located in the PageFields. |
| [ShowReportFilterPageByName(const char16_t* fieldName)](./showreportfilterpagebyname/) | Show all the report filter pages according to [PivotField](../pivotfield/)'s name, the [PivotField](../pivotfield/) must be located in the PageFields. |
| [~PivotTable()](./~pivottable/) | Destructor. |
## Fields

| Field | Description |
| --- | --- |
| [_impl](./_impl/) | The implementation object. |

## Examples


```cpp
Aspose::Cells::Startup();
Workbook book;
Worksheet sheet = book.GetWorksheets().Get(0);
Cells cells = sheet.GetCells();
cells.Get(0, 0).PutValue(u"fruit");
cells.Get(1, 0).PutValue(u"grape");
cells.Get(2, 0).PutValue(u"blueberry");
cells.Get(3, 0).PutValue(u"kiwi");
cells.Get(4, 0).PutValue(u"cherry");
cells.Get(5, 0).PutValue(u"grape");
cells.Get(6, 0).PutValue(u"blueberry");
cells.Get(7, 0).PutValue(u"kiwi");
cells.Get(8, 0).PutValue(u"cherry");

cells.Get(0, 1).PutValue(u"year");
cells.Get(1, 1).PutValue(2020);
cells.Get(2, 1).PutValue(2020);
cells.Get(3, 1).PutValue(2020);
cells.Get(4, 1).PutValue(2020);
cells.Get(5, 1).PutValue(2021);
cells.Get(6, 1).PutValue(2021);
cells.Get(7, 1).PutValue(2021);
cells.Get(8, 1).PutValue(2021);

cells.Get(0, 2).PutValue(u"amount");
cells.Get(1, 2).PutValue(50);
cells.Get(2, 2).PutValue(60);
cells.Get(3, 2).PutValue(70);
cells.Get(4, 2).PutValue(80);
cells.Get(5, 2).PutValue(90);
cells.Get(6, 2).PutValue(100);
cells.Get(7, 2).PutValue(110);
cells.Get(8, 2).PutValue(120);

PivotTableCollection pivots = sheet.GetPivotTables();

int pivotIndex = pivots.Add(u"=Sheet1!A1:C9", u"A12", u"TestPivotTable");
PivotTable pivot = pivots.Get(pivotIndex);
pivot.AddFieldToArea(PivotFieldType::Row, u"fruit");
pivot.AddFieldToArea(PivotFieldType::Column, u"year");
pivot.AddFieldToArea(PivotFieldType::Data, u"amount");

pivot.SetPivotTableStyleType(PivotTableStyleType::PivotTableStyleMedium10);

//Change PivotField's attributes
PivotField rowField = pivot.GetRowFields().Get(0);
rowField.SetDisplayName(u"custom display name");

//Add PivotFilter
int index = pivot.GetPivotFilters().Add(0, PivotFilterType::Count);
PivotFilter filter = pivot.GetPivotFilters().Get(index);
filter.GetAutoFilter().FilterTop10(0, false, false, 2);

//Add PivotFormatCondition
int formatIndex = pivot.GetPivotFormatConditions().Add();
PivotFormatCondition pfc = pivot.GetPivotFormatConditions().Get(formatIndex);
FormatConditionCollection fcc = pfc.GetFormatConditions();
fcc.AddArea(pivot.GetDataBodyRange());
int idx = fcc.AddCondition(FormatConditionType::CellValue);
FormatCondition fc = fcc.Get(idx);
fc.SetFormula1(u"100");
fc.SetOperator(OperatorType::GreaterOrEqual);
fc.GetStyle().SetBackgroundColor(Color{ 0xff, 0xff, 0, 0 });//Red

PivotTableCalculateOption calculateOption;
calculateOption.SetRefreshData(true);
calculateOption.SetRefreshCharts(true);
pivot.CalculateData(calculateOption);


book.Save("out.xlsx");

Aspose::Cells::Cleanup();
```

## See Also

* Namespace [Aspose::Cells::Pivot](../)
* Library [Aspose.Cells for C++](../../)