Sub-category percent calculation

Question

Hi everyone,

I need your help: I want to know how can I calculate a percentage of a subcategory in a database using, of course,  ALTERYX. Like these example that I attached in Excel, for example: the percent of the total price for each category (S, M &L). I know how to do it in Excel, but not in Alteryx.

Thanks for your time.😁

Percent.xlsx

grazitti_sapna · Answer

Hi @KatyKab 
Please give a look!
Hope it works for you.
Thanks

Calculate_Percentage.yxmd

Qiu · Answer

@KatyKab 
There are a few handy functions in the Summarize Tool which may suit your requirement.

1117-KatyKab.yxmd

flying008 · Answer

Hi, @KatyKab

Please give your want output percent value in table.