Forum Discussion
Grouping in a pivot
Hello, I would like to group the data into ranges but when I follow the instruction I found on internet for grouping what happens is that all the values are grouped into a single group (as you can se...
Hello Hans,
thank you for the reply what I would like to have is to group the data into ranges. I have found on internet that if you right click on a cell then you should have a context menu and you should be able to define the range of values.
However, when I follow the process I do not get the context menu and if I select all the values and I click group what I obtain is what you can see in the screenshot
thank you for the reply what I would like to have is to group the data into ranges. I have found on internet that if you right click on a cell then you should have a context menu and you should be able to define the range of values.
However, when I follow the process I do not get the context menu and if I select all the values and I click group what I obtain is what you can see in the screenshot
Have you tried selecting a single cell in he Row Labels area of the pivot table?
You should get a context menu with Group... in it.
Clicking Group... results in a dialog:
If you don't see the context menu: which version of Excel do you use? The desktop version for Windows or Mac, or the online (browser) version, or the iOS/Android version?
Yes I did select a cell in the row label column but when I click it I get this message
I have no idea about how to solve it
Do your row labels contain text values? Excel cannot group text values.