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.

Alteryx Pct Total.xlsx

gabrielvilella

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

Percentage.yxmd