Hello everyone,
I have a graph which diplays the sales per city and per geographical zone. I would like to have another graph which displays percentages per city inside a zone, ie. for one zone, the total will be 100%.
My current expression is :
SUM([Sales]) / TOTAL (SUM ([Sales]))
I don't know how to specify in the second part that I want the total per zone instead of the general total.
Thank you for your help
Laura
Hi Laura,
In above image you can see that by right click on your Percentage Sales you can get Compute using & that is computed according to State. This divides your % sales according to Market.
Attaching a link from where you can learn it properly - http://www.tableausoftware.com/sites/default/files/pages/table_calcs_in_tableau_6.pdf
Warm Regards,
