Jul 14 2022 02:32 AM
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 see in the screen). How can I select different ranges?
Thank you!
Jul 14 2022 02:58 AM
One way would be to define the groups in an additional column in the source data.
But you can also specify the groups in the pivot table itself:
First, ungroup the row labels.
Then select the values you want in the first group.
Right-click in the selection and select Group... from the context menu.
All values outside the selection will be in a group of their own.
Select the ones you want to be in the second group, right-click and select Group...
Repeat as long as needed.
Jul 14 2022 03:04 AM
Jul 14 2022 04:11 AM - edited Jul 14 2022 04:12 AM
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?
Jul 14 2022 04:27 AM
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
Jul 14 2022 04:57 AM
Do your row labels contain text values? Excel cannot group text values.
Jul 14 2022 05:02 AM
Jul 14 2022 05:08 AM
What is the "-"? That doesn't look like a number...
Jul 14 2022 06:28 AM
Yes I had to delete it manually (I was just filtering it out).
Can I ask you another question regarding the grouping?
How can I manage to do the subgroups like the screenshot? I managed to do the normal ones while I cannot do the bold ones..
Thanks!
Jul 14 2022 06:47 AM
The only way I can think of is to use additional columns in the source data. Let's see if someone else comes up with a better idea.