Forum Discussion
Pivot Table: Grouping doesn't work (tried almost everything)
Hi community, I'm trying to use the "group" function in PivotTables but it always says "cannot group the selected area", without further information. I've strictly followed Microsoft's instruction an...
If you want tell us….
What field you’re grouping (dates? numbers?)
Whether the PivotTable uses the Data Model
How the data is sourced (manual / CSV / PQ)
This would allow for a more precise identification of the cause and the provision of targeted solutions.
Welcome to your Excel discussion space!
Thank you for your understanding and patience
I know I don't know anything (Socrates)
Thanx for your help! I've tried all of this, nothing worked. But I found the problem (and solution) somewhere completely different: When creating the PivotTable, there was a box checked ("add data to data model") which shouldn't have been activated - it prevented the later grouping of data. Once unchecked/removed, everything worked as it should... Thanx anyway!
