Jan 01 2023 10:37 AM
Hello everyone,
I'm wondering when grouping data in a pivot chart, is it possible that I can remove the redundant (or duplicated) levels automatically created by grouping when my data has a various number of levels?
An example is provided in the following screenshot. If A, B forms a team, and A, B and C form another larger team, but D herself forms a team, and I want to group the data to review the team's performance.
Is it possible that I can remove the extra hierarchies under C and D (highlighted in green and yellow)? I also include what I expect on the right of the screenshot. I know I can either hide or collapse the extra rows, but out of my curiosity, I would like to know if there are some other ways that I can completely get rid of those extra lines.
Thanks for your help!
Happy new year :)