sum categories to one in table

[Anonymous]

Hi,

I upload an excel file with some categories to the PBI.

Now all the categories have their row but the three categories R&G coffee, Beans, and Capsules need to be R&G Total, and the three categories Instant coffee - Powder, Freeze dry and Instant coffee - Microgrinding need to be Instant Total and the sum of R&G Total and Instant coffee need to be Total Product Group.

What I need to do that I will see only Total Product Group and when I press + I will see the next level and cetera.

Now there Are duplicates in the data.

Thank you!

[bsheffer]

sounds like you need to create some calculated columns so each category has an aggregate label as well.  Then you can put then in a matrix and drill down and total.