Courses / PivotTables & PivotCharts
13. Ungrouping grouped fields
Reverting grouped fields back to their original individual members.
1 min read Chapter 13 of 33
PivotTables and PivotCharts (Excel)
Ungrouping grouped fields
Removing a grouping so the PivotField shows each original member again.
"I grouped months into quarters, but now I need to show every month again — how do I revert that?"
Ungrouping restores a grouped PivotField back to its original items (members) so the PivotTable or PivotChart displays individual entries instead of the grouped buckets.
"I grouped months into quarters, but now I need to show every month again — how do I revert that?"
Ungrouping restores a grouped PivotField back to its original items (members) so the PivotTable or PivotChart displays individual entries instead of the grouped buckets.