Ungroups all selected groups within a PivotTable report.
Syntax
PIVOT.FIELD.UNGROUP( )
Remark
If the active cell is on a field header, then all the groups in that field are ungrouped and the field will be removed from the PivotTable report. Similarly, if the last group in a Parent field is ungrouped, the entire field will be removed from the PivotTable report.
Related Functions
PIVOT.ADD.DATA Adds a field to a PivotTable report as a data field
PIVOT.ADD.FIELDS Adds fields to a PivotTable report
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.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