Bar Chart % of Total

[schmidtkm37]

Hello,

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.

Thank you,

Kevin

[Qrishna · Accepted solution]

Try (Sum(Sales)/Sum(TOTAL Sales))

[schmidtkm37]

Thanks!