My data has a sales item for which I know total sales and the number of those sales which required customer support. I would like to be able to dynamically calculate the percent requiring customer support of all sales for that item. Also, if I were to filter the items, (for example, by total sales dollar amount), I would then want to see the new total sales and the percent requiring customer support of that new number of total sales.

So, my result table would have 100 rows if I had 100 types of items sold. My filters are fields like region, color, price range, etc.
thank you