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...
Do your row labels contain text values? Excel cannot group text values.
What is the "-"? That doesn't look like a number...
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!
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.