Class PivotTable
Namespace: Aspose.Cells.Pivot
Assembly: Aspose.Cells.dll (25.2.0)
Summary description for PivotTable.
public class PivotTable : IDisposableInheritance
Implements
Inherited Members
object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Examples
Workbook book = new Workbook();
Worksheet sheet = book.Worksheets[0];
Cells cells = sheet.Cells;
cells[0, 0].Value = "fruit";
cells[1, 0].Value = "grape";
cells[2, 0].Value = "blueberry";
cells[3, 0].Value = "kiwi";
cells[4, 0].Value = "cherry";
cells[5, 0].Value = "grape";
cells[6, 0].Value = "blueberry";
cells[7, 0].Value = "kiwi";
cells[8, 0].Value = "cherry";
cells[0, 1].Value = "year";
cells[1, 1].Value = 2020;
cells[2, 1].Value = 2020;
cells[3, 1].Value = 2020;
cells[4, 1].Value = 2020;
cells[5, 1].Value = 2021;
cells[6, 1].Value = 2021;
cells[7, 1].Value = 2021;
cells[8, 1].Value = 2021;
cells[0, 2].Value = "amount";
cells[1, 2].Value = 50;
cells[2, 2].Value = 60;
cells[3, 2].Value = 70;
cells[4, 2].Value = 80;
cells[5, 2].Value = 90;
cells[6, 2].Value = 100;
cells[7, 2].Value = 110;
cells[8, 2].Value = 120;
PivotTableCollection pivots = sheet.PivotTables;
int pivotIndex = pivots.Add("=Sheet1!A1:C9", "A12", "TestPivotTable");
PivotTable pivot = pivots[pivotIndex];
pivot.AddFieldToArea(PivotFieldType.Row, "fruit");
pivot.AddFieldToArea(PivotFieldType.Column, "year");
pivot.AddFieldToArea(PivotFieldType.Data, "amount");
pivot.PivotTableStyleType = PivotTableStyleType.PivotTableStyleMedium10;
//Change PivotField's attributes
PivotField rowField = pivot.RowFields[0];
rowField.DisplayName = "custom display name";
//Add PivotFilter
int index = pivot.PivotFilters.Add(0, PivotFilterType.Count);
PivotFilter filter = pivot.PivotFilters[index];
filter.AutoFilter.FilterTop10(0, false, false, 2);
//Add PivotFormatCondition
int formatIndex = pivot.PivotFormatConditions.Add();
PivotFormatCondition pfc = pivot.PivotFormatConditions[formatIndex];
FormatConditionCollection fcc = pfc.FormatConditions;
fcc.AddArea(pivot.DataBodyRange);
int idx = fcc.AddCondition(FormatConditionType.CellValue);
FormatCondition fc = fcc[idx];
fc.Formula1 = "100";
fc.Operator = OperatorType.GreaterOrEqual;
fc.Style.BackgroundColor = Color.Red;
pivot.RefreshData();
pivot.CalculateData();
//do your business
book.Save("out.xlsx");Dim book As Workbook = New Workbook()
Dim sheet As Worksheet = book.Worksheets(0)
Dim cells As Cells = sheet.Cells
cells(0, 0).Value = "fruit"
cells(1, 0).Value = "grape"
cells(2, 0).Value = "blueberry"
cells(3, 0).Value = "kiwi"
cells(4, 0).Value = "cherry"
cells(5, 0).Value = "grape"
cells(6, 0).Value = "blueberry"
cells(7, 0).Value = "kiwi"
cells(8, 0).Value = "cherry"
cells(0, 1).Value = "year"
cells(1, 1).Value = 2020
cells(2, 1).Value = 2020
cells(3, 1).Value = 2020
cells(4, 1).Value = 2020
cells(5, 1).Value = 2021
cells(6, 1).Value = 2021
cells(7, 1).Value = 2021
cells(8, 1).Value = 2021
cells(0, 2).Value = "amount"
cells(1, 2).Value = 50
cells(2, 2).Value = 60
cells(3, 2).Value = 70
cells(4, 2).Value = 80
cells(5, 2).Value = 90
cells(6, 2).Value = 100
cells(7, 2).Value = 110
cells(8, 2).Value = 120
Dim pivots As PivotTableCollection = sheet.PivotTables
Dim pivotIndex As Int32 = pivots.Add("=Sheet1!A1:C9", "A12", "TestPivotTable")
Dim pivot As PivotTable = pivots(pivotIndex)
pivot.AddFieldToArea(PivotFieldType.Row, "fruit")
Pivot.AddFieldToArea(PivotFieldType.Column, "year")
Pivot.AddFieldToArea(PivotFieldType.Data, "amount")
pivot.PivotTableStyleType = PivotTableStyleType.PivotTableStyleMedium10
'Change PivotField's attributes
Dim rowField As PivotField = pivot.RowFields(0)
rowField.DisplayName = "custom display name"
'Add PivotFilter
Dim filterIndex As Int32 = pivot.PivotFilters.Add(0, PivotFilterType.Count)
Dim filter As PivotFilter = pivot.PivotFilters(filterIndex)
filter.AutoFilter.FilterTop10(0, False, False, 2)
'Add PivotFormatCondition
Dim formatIndex As Int32 = pivot.PivotFormatConditions.Add()
Dim pfc As PivotFormatCondition = pivot.PivotFormatConditions(formatIndex)
Dim fcc As FormatConditionCollection = pfc.FormatConditions
fcc.AddArea(pivot.DataBodyRange)
Dim idx As Int32 = fcc.AddCondition(FormatConditionType.CellValue)
Dim fc As FormatCondition = fcc(idx)
fc.Formula1 = "100"
fc.Operator = OperatorType.GreaterOrEqual
fc.Style.BackgroundColor = Color.Red
pivot.RefreshData()
pivot.CalculateData()
book.Save("out_vb.xlsx")Properties
AllowMultipleFiltersPerField
Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them.
public bool AllowMultipleFiltersPerField { get; set; }Property Value
AltTextDescription
Gets the description of the alt text.
public string AltTextDescription { get; set; }Property Value
AltTextTitle
Gets and sets the title of the alter text.
public string AltTextTitle { get; set; }Property Value
AutoFormatType
Gets and sets the auto format type of PivotTable.
public PivotTableAutoFormatType AutoFormatType { get; set; }Property Value
AutofitColumnWidthOnUpdate
Indicates whether autofitting column width on update
public bool AutofitColumnWidthOnUpdate { get; set; }Property Value
BaseFields
Returns all base pivot fields in the PivotTable.
public PivotFieldCollection BaseFields { get; }Property Value
ColumnFields
Returns a PivotFields object that are currently shown as column fields.
public PivotFieldCollection ColumnFields { get; }Property Value
ColumnHeaderCaption
Gets the Column Header Caption of the PivotTable.
public string ColumnHeaderCaption { get; set; }Property Value
ColumnRange
Returns a CellArea object that represents the range that contains the column area in the PivotTable report. Read-only.
public CellArea ColumnRange { get; }Property Value
ConditionalFormats
Gets the conditional formats of the pivot table.
public PivotConditionalFormatCollection ConditionalFormats { get; }Property Value
PivotConditionalFormatCollection
CustomListSort
Indicates whether consider built-in custom list when sort data
public bool CustomListSort { get; set; }Property Value
DataBodyRange
Returns a 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.
public CellArea DataBodyRange { get; }Property Value
DataField
Gets a Aspose.Cells.Pivot.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() method .
public PivotField DataField { get; }Property Value
DataFieldHeaderName
Gets and sets the name of the value area field header in the PivotTable.
public string DataFieldHeaderName { get; set; }Property Value
DataFields
Gets a 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.
public PivotFieldCollection DataFields { get; }Property Value
DataSource
Gets and sets the data source of the pivot table.
public string[] DataSource { get; set; }Property Value
string[]
DisplayErrorString
Indicates whether the PivotTable report displays a custom string in cells that contain errors.
public bool DisplayErrorString { get; set; }Property Value
DisplayImmediateItems
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.
public bool DisplayImmediateItems { get; set; }Property Value
DisplayNullString
Indicates whether the PivotTable report displays a custom string if the value is null.
public bool DisplayNullString { get; set; }Property Value
EnableDataValueEditing
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
public bool EnableDataValueEditing { get; set; }Property Value
EnableDrilldown
Gets whether drilldown is enabled.
public bool EnableDrilldown { get; set; }Property Value
EnableFieldDialog
Indicates whether the PivotTable Field dialog box is available when the user double-clicks the PivotTable field.
public bool EnableFieldDialog { get; set; }Property Value
EnableFieldList
Indicates whether the field list for the PivotTable is available on the view of Excel.
public bool EnableFieldList { get; set; }Property Value
EnableWizard
Indicates whether the PivotTable Wizard is available.
public bool EnableWizard { get; set; }Property Value
ErrorString
Gets the string displayed in cells that contain errors when the DisplayErrorString property is true.The default value is an empty string.
public string ErrorString { get; set; }Property Value
FieldListSortAscending
Indicates whether fields in the PivotTable are sorted in non-default order in the field list.
public bool FieldListSortAscending { get; set; }Property Value
GrandTotalName
Returns the label that is displayed in the grand total column or row heading. The default value is the string “Grand Total”.
public string GrandTotalName { get; set; }Property Value
HasBlankRows
Indicates whether to add blank rows. This property only applies for the PivotTable auto format types which needs to add blank rows.
public bool HasBlankRows { get; set; }Property Value
Indent
Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form.
public int Indent { get; set; }Property Value
IsAutoFormat
Indicates whether the PivotTable report is automatically formatted. Checkbox “autoformat table " which is in pivottable option for Excel 2003
public bool IsAutoFormat { get; set; }Property Value
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.
public bool IsExcel2003Compatible { get; set; }Property Value
IsGridDropZones
Indicates whether the PivotTable report displays classic pivottable layout. (enables dragging fields in the grid)
public bool IsGridDropZones { get; set; }Property Value
IsSelected
Indicates whether this PivotTable is selected.
public bool IsSelected { get; set; }Property Value
ManualUpdate
Indicates whether the PivotTable report is recalculated only at the user’s request.
public bool ManualUpdate { get; set; }Property Value
MergeLabels
True if the specified PivotTable report’s outer-row item, column item, subtotal, and grand total labels use merged cells.
public bool MergeLabels { get; set; }Property Value
MissingItemsLimit
Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them.
public PivotMissingItemLimitType MissingItemsLimit { get; set; }Property Value
Name
Gets the name of the PivotTable
public string Name { get; set; }Property Value
NullString
Gets the string displayed in cells that contain null values when the DisplayNullString property is true.The default value is an empty string.
public string NullString { get; set; }Property Value
PageFieldOrder
Gets and sets the order in which page fields are added to the PivotTable report’s layout.
public PrintOrderType PageFieldOrder { get; set; }Property Value
PageFieldWrapCount
Gets the number of page fields in each column or row in the PivotTable report.
public int PageFieldWrapCount { get; set; }Property Value
PageFields
Returns a PivotFields object that are currently shown as page fields.
public PivotFieldCollection PageFields { get; }Property Value
PivotFilters
Returns all filters of pivot fields in the pivot table.
public PivotFilterCollection PivotFilters { get; }Property Value
PivotFormats
Gets the collection of formats applied to PivotTable.
public PivotTableFormatCollection PivotFormats { get; }Property Value
PivotTableStyleName
Gets and sets the pivottable style name.
public string PivotTableStyleName { get; set; }Property Value
PivotTableStyleType
Gets and sets the built-in pivot table style.
public PivotTableStyleType PivotTableStyleType { get; set; }Property Value
PreserveFormatting
Indicates whether formatting is preserved when the PivotTable is refreshed or recalculated.
public bool PreserveFormatting { get; set; }Property Value
PrintDrill
Specifies a boolean value that indicates whether drill indicators should be printed. print expand/collapse buttons when displayed on pivottable.
public bool PrintDrill { get; set; }Property Value
PrintTitles
Indicates whether the print titles for the worksheet are set based on the PivotTable report. The default value is false.
public bool PrintTitles { get; set; }Property Value
RefreshDataOnOpeningFile
Indicates whether Refresh Data when Opening File.
public bool RefreshDataOnOpeningFile { get; set; }Property Value
RefreshDate
Gets the last date time when the PivotTable was refreshed.
public DateTime RefreshDate { get; }Property Value
RefreshedByWho
Gets the name of the last user who refreshed this PivotTable
public string RefreshedByWho { get; }Property Value
RepeatItemsOnEachPrintedPage
Indicates whether pivot item captions on the row area are repeated on each printed page for pivot fields in tabular form.
public bool RepeatItemsOnEachPrintedPage { get; set; }Property Value
RowFields
Returns a PivotFields object that are currently shown as row fields.
public PivotFieldCollection RowFields { get; }Property Value
RowHeaderCaption
Gets the Row Header Caption of the PivotTable.
public string RowHeaderCaption { get; set; }Property Value
RowRange
Returns a CellArea object that represents the range that contains the row area in the PivotTable report. Read-only.
public CellArea RowRange { get; }Property Value
SaveData
Indicates whether data for the PivotTable report is saved with the workbook.
public bool SaveData { get; set; }Property Value
ShowColumnGrandTotals
Indicates whether to show grand totals for columns of this pivot table.
public bool ShowColumnGrandTotals { get; set; }Property Value
ShowDataTips
Specifies a boolean value that indicates whether tooltips should be displayed for PivotTable data cells.
public bool ShowDataTips { get; set; }Property Value
ShowDrill
Gets and sets whether showing expand/collapse buttons.
public bool ShowDrill { get; set; }Property Value
ShowEmptyCol
Indicates whether to include empty columns in the table
public bool ShowEmptyCol { get; set; }Property Value
ShowEmptyRow
Indicates whether to include empty rows in the table.
public bool ShowEmptyRow { get; set; }Property Value
ShowMemberPropertyTips
Specifies a boolean value that indicates whether member property information should be omitted from PivotTable tooltips.
public bool ShowMemberPropertyTips { get; set; }Property Value
ShowPivotStyleColumnHeader
Indicates whether the column header in the pivot table should have the style applied.
public bool ShowPivotStyleColumnHeader { get; set; }Property Value
ShowPivotStyleColumnStripes
Indicates whether stripe formatting is applied for column.
public bool ShowPivotStyleColumnStripes { get; set; }Property Value
ShowPivotStyleLastColumn
Indicates whether the column formatting is applied.
public bool ShowPivotStyleLastColumn { get; set; }Property Value
ShowPivotStyleRowHeader
Indicates whether the row header in the pivot table should have the style applied.
public bool ShowPivotStyleRowHeader { get; set; }Property Value
ShowPivotStyleRowStripes
Indicates whether row stripe formatting is applied.
public bool ShowPivotStyleRowStripes { get; set; }Property Value
ShowRowGrandTotals
Indicates whether to show grand totals for rows of the pivot table.
public bool ShowRowGrandTotals { get; set; }Property Value
ShowRowHeaderCaption
Indicates whether row header caption is shown in the PivotTable report Indicates whether Display field captions and filter drop downs
public bool ShowRowHeaderCaption { get; set; }Property Value
ShowValuesRow
Indicates whether showing values row.
public bool ShowValuesRow { get; set; }Property Value
SourceType
Gets the data source type of the pivot table.
public PivotTableSourceType SourceType { get; }Property Value
SubtotalHiddenPageItems
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.
public bool SubtotalHiddenPageItems { get; set; }Property Value
TableRange1
Returns a CellArea object that represents the range containing the entire PivotTable report, but doesn’t include page fields. Read-only.
public CellArea TableRange1 { get; }Property Value
TableRange2
Returns a CellArea object that represents the range containing the entire PivotTable report, includes page fields. Read-only.
public CellArea TableRange2 { get; }Property Value
Tag
Gets a string saved with the PivotTable report.
public string Tag { get; set; }Property Value
Methods
AddCalculatedField(string, string, bool)
Adds a calculated field to pivot field.
public void AddCalculatedField(string name, string formula, bool dragToDataArea)Parameters
name string
The name of the calculated field
formula string
The formula of the calculated field.
dragToDataArea bool
True,drag this field to data area immediately
AddCalculatedField(string, string)
Adds a calculated field to pivot field and drag it to data area.
public void AddCalculatedField(string name, string formula)Parameters
name string
The name of the calculated field
formula string
The formula of the calculated field.
AddFieldToArea(PivotFieldType, string)
Adds the field to the specific area.
public int AddFieldToArea(PivotFieldType fieldType, string fieldName)Parameters
fieldType PivotFieldType
The fields area type.
fieldName string
The name in the base fields.
Returns
The field position in the specific fields.If there is no field named as it, return -1.
AddFieldToArea(PivotFieldType, int)
Adds the field to the specific area.
public int AddFieldToArea(PivotFieldType fieldType, int baseFieldIndex)Parameters
fieldType PivotFieldType
The fields area type.
baseFieldIndex int
The field index in the base fields.
Returns
The field position in the specific fields.
AddFieldToArea(PivotFieldType, PivotField)
Adds the field to the specific area.
public int AddFieldToArea(PivotFieldType fieldType, PivotField pivotField)Parameters
fieldType PivotFieldType
the fields area type.
pivotField PivotField
the field in the base fields.
Returns
the field position in the specific fields.
CalculateData()
Calculates pivottable’s data to cells.
public void CalculateData()Remarks
Cell.Value in the pivot range could not return the correct result if the method is not been called. This method calculates data with an inner pivot cache,not original data source. So if the data source is changed, please call RefreshData() method first.
CalculateData(PivotTableCalculateOption)
Calculating pivot tables with options
public void CalculateData(PivotTableCalculateOption option)Parameters
option PivotTableCalculateOption
CalculateRange()
Calculates pivottable’s range.
public void CalculateRange()Remarks
If this method is not been called,maybe the pivottable range is not corrected.
ChangeDataSource(string[])
Set pivottable’s source data.
public void ChangeDataSource(string[] source)Parameters
source string[]
ClearData()
Clear PivotTable’s data and formatting
public void ClearData()Remarks
If this method is not called before you add or delete PivotField, Maybe the PivotTable data is not corrected
CopyStyle(PivotTable)
Copies named style from another pivot table.
public void CopyStyle(PivotTable pivotTable)Parameters
pivotTable PivotTable
Source pivot table.
Dispose()
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
public void Dispose()Format(PivotArea, Style)
Formats selected area of the PivotTable.
public void Format(PivotArea pivotArea, Style style)Parameters
pivotArea PivotArea
The selected pivot view area.
style Style
The formatted setting.
Format(CellArea, Style)
Formats selected area of the PivotTable.
public void Format(CellArea ca, Style style)Parameters
ca CellArea
The range of the cells.
style Style
The style
Format(int, int, Style)
Format the cell in the pivottable area
public void Format(int row, int column, Style style)Parameters
row int
Row Index of the cell
column int
Column index of the cell
style Style
Style which is to format the cell
FormatAll(Style)
Format all the cell in the pivottable area
public void FormatAll(Style style)Parameters
style Style
Style which is to format
FormatRow(int, Style)
Format the row data in the pivottable area
public void FormatRow(int row, Style style)Parameters
row int
Row Index of the Row object
style Style
Style which is to format
GetCellByDisplayName(string)
Gets the Aspose.Cells.Cell object by the display name of PivotField.
public Cell GetCellByDisplayName(string displayName)Parameters
displayName string
the DisplayName of PivotField
Returns
the Cell object
GetChildren()
Gets the Children Pivot Tables which use this PivotTable data as data source.
public PivotTable[] GetChildren()Returns
the PivotTable array object
GetFields(PivotFieldType)
Gets the specific pivot field list by the region.
public PivotFieldCollection GetFields(PivotFieldType fieldType)Parameters
fieldType PivotFieldType
the region type.
Returns
the specific pivot field collection
GetHorizontalPageBreaks()
Gets horizontal page breaks of this pivot table.
public int[] GetHorizontalPageBreaks()Returns
int[]
GetNamesOfSourceDataConnections()
Gets the name of external source data connections.
public string[] GetNamesOfSourceDataConnections()Returns
string[]
GetSource()
Get pivottable’s source data.
public string[] GetSource()Returns
string[]
GetSource(bool)
Get pivottable’s source data.
public string[] GetSource(bool isOriginal)Parameters
isOriginal bool
Indicates whether to return original or display data source
Returns
string[]
GetSourceDataConnections()
Gets the external connection data sources.
public ExternalConnection[] GetSourceDataConnections()Returns
MoveTo(int, int)
Moves the PivotTable to a different location in the worksheet.
public void MoveTo(int row, int column)Parameters
row int
row index.
column int
column index.
MoveTo(string)
Moves the PivotTable to a different location in the worksheet.
public void MoveTo(string destCellName)Parameters
destCellName string
the dest cell name.
RefreshData()
Refreshes pivottable’s data and setting from it’s data source.
public PivotRefreshState RefreshData()Returns
Remarks
We will gather data from data source to a pivot cache ,then calculate the data in the cache to the cells. This method is only used to gather all data to a pivot cache.
RefreshData(PivotTableRefreshOption)
Refreshes pivottable’s data and setting from it’s data source with options.
public PivotRefreshState RefreshData(PivotTableRefreshOption option)Parameters
option PivotTableRefreshOption
The options for refreshing data source of pivot table.
Returns
RemoveField(PivotFieldType, string)
Removes a field from specific field area
public void RemoveField(PivotFieldType fieldType, string fieldName)Parameters
fieldType PivotFieldType
The fields area type.
fieldName string
The name in the base fields.
RemoveField(PivotFieldType, int)
Removes a field from specific field area
public void RemoveField(PivotFieldType fieldType, int baseFieldIndex)Parameters
fieldType PivotFieldType
The fields area type.
baseFieldIndex int
The field index in the base fields.
RemoveField(PivotFieldType, PivotField)
Remove field from specific field area
public void RemoveField(PivotFieldType fieldType, PivotField pivotField)Parameters
fieldType PivotFieldType
the fields area type.
pivotField PivotField
the field in the base fields.
SelectArea(CellArea)
Select an area of pivot table view.
public PivotAreaCollection SelectArea(CellArea ca)Parameters
ca CellArea
The cell area.
Returns
ShowDetail(int, int, bool, int, int)
Show the detail of one item in the data region to a new Table.
public void ShowDetail(int rowOffset, int columnOffset, bool newSheet, int destRow, int destColumn)Parameters
rowOffset int
Offset to the first data row in the data region.
columnOffset int
Offset to the first data column in the data region.
newSheet bool
Show the detail to a new worksheet.
destRow int
The target row.
destColumn int
The target column.
ShowInCompactForm()
Layouts the PivotTable in compact form.
public void ShowInCompactForm()ShowInOutlineForm()
Layouts the PivotTable in outline form.
public void ShowInOutlineForm()ShowInTabularForm()
Layouts the PivotTable in tabular form.
public void ShowInTabularForm()ShowReportFilterPage(PivotField)
Show all the report filter pages according to PivotField, the PivotField must be located in the PageFields.
public void ShowReportFilterPage(PivotField pageField)Parameters
pageField PivotField
The PivotField object
ShowReportFilterPageByIndex(int)
Show all the report filter pages according to the position index in the PageFields
public void ShowReportFilterPageByIndex(int posIndex)Parameters
posIndex int
The position index in the PageFields
ShowReportFilterPageByName(string)
Show all the report filter pages according to PivotField’s name, the PivotField must be located in the PageFields.
public void ShowReportFilterPageByName(string fieldName)Parameters
fieldName string
The name of PivotField