Pie Chart with percent data on multiple columns

Hi v-yingjl,

Thank you! That did work partly, but I still have a couple of issues where I would love to get your insights:

1. By creating a separate table, I lost the ability to filter my data dynamically. Is there a way I can add another column onto this table "ID" and then create a relationship between both tables so I don't lose the filtering functionality?
2. Although it grouped the items of some of the tables, I only got 28 in the pie chart when the real count is 46. Any ideas on what could be trigering this?
   
   Thanks