I am trying to get a bar chart that shows each sub category as a % of the sales of the entire category. For example, if we have subcategory A, B and C and they have sales of $2, $3 and $5 (total of $10), I would want a bar chart with A, B and C showing values 20%, 30% and 50%.
So I need a calculation that allows me to do sum(sales) / sum(sales for entire category)
Anybody know if this is possible? Your help is greatly appreciated.