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

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!