Grouping columns while keeping original values and using this to create a hierarchy

[Finlayk99]

Hi,

I have a table with different columns breaking down different payments. I want to group these columns into tax detuctible and non- detucible while keeping the orginal values so i can have a pie chart of non-deductable against tax-deductable and then drill down into the individual components. I tried hierarchy but that wont allow me to use the hierarchy as a values.

Any suggestions would be greatly appreciated.

Thank you!

[v-easonf-msft]

Hi, @Finlayk99 

You may need to make adjustments to the model and then apply the hierarchy to the "Legend" of pie chart.

Best Regards,
Community Support Team _ Eason