Add fields onto a PivotTable report.
Syntax
PIVOT.ADD.FIELDS(name, row_array, column_array, page_array, add_to_table)
Name is the name of the PivotTable report to which the user wants to add fields. If name is omitted, Microsoft Excel will use the PivotTable report containing the active cell.
Row_array is an array of text constants consisting of the names of the fields which the user would like to add to the PivotTable report as row fields.
Column_array is an array of text constants consisting of the names of the fields which the user would like to add to the PivotTable report as column fields.
Page_array is an array of text constants consisting of the names of the fields which the user would like to add to the PivotTable report as page fields.
Add_to_table is a logical value which if TRUE adds the fields specified by row_array, column_array and page_array to the existing fields on the PivotTable report. If add_to_table is FALSE, Microsoft Excel will replace the fields already along the rows, columns and pages with the fields specified by row_array, column_array and page_array.
Remarks
If name is not a valid PivotTable name, then the #VALUE! error value is returned.
Related Functions
PIVOT.ADD.DATA Adds a field to a PivotTable report as a data field
PIVOT.FIELD Pivots fields within a PivotTable report
PIVOT.FIELD.GROUP Creates groups within a PivotTable report
PIVOT.FIELD.PROPERTIES Changes the properties of a field inside a PivotTable report
PIVOT.FIELD.UNGROUP Ungroups all selected groups within a PivotTable report
PIVOT.ITEM Moves an item within a PivotTable report
PIVOT.ITEM.PROPERTIES Changes the properties of an item within a header field
PIVOT.REFRESH Refreshes a PivotTable report
PIVOT.SHOW.PAGES Creates new sheets in the workbook containing the active cell
PIVOT.TABLE.WIZARD Creates an empty PivotTable report
Return to index