Calculating % of Total

[AlterIT]

I have a dataset where I try to find out % of Total of a metric by other dimensions. Since it has multiple dimensions I am not getting it right when I use summarize tool do that.

In this dataset I have profit metric where I need to find out Profit % of Total by component within each City/Recipe combination. I have highlighted in red what is required, other columns are base data.

Thanks in advance.

[gabrielvilella · Accepted solution]

Hi @AlterIT, you just need to calculate the total using a Summarize then join the values so you can calculate the percentage.

[Qiu]

@AlterIT 
A bit different approach.