Grouping multiple columns together

[PCarson00]

I have a stacked chart that has lots of columns and is difficult to read.

These columns also have a heirarchy above them, so can be grouped into less chunks. In the excel document, this is a merged cell above the column headers.

Is there a way to include these or by way of using filters to gather these together?

[Anonymous]

Hello @PCarson00 ,

What you can do is just make a measure that Sums all those different parts together. EX. GROUP 1= SUM(A) + SUM(B) + SUM(C) + SUM(D) / EX. GROUP 2 = SUM(D) + SUM(E) + SUM(F) + SUM(G)

[PCarson00]

Thanks that has worked but is there a way to drill down on those fields now. If I click on those columns, would it be possible to see what thats made up of, or have a list with those specific skills that once clicked, would break it down?