Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Sub-category percent calculation

KatyKab
6 - Meteoroid

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.😁

3 REPLIES 3
flying008
15 - Aurora

Hi, @KatyKab 

 

Please give your want output percent value in table.

 

录制_2023_11_17_11_21_16_703.gif

Qiu
21 - Polaris
21 - Polaris

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

1117-KatyKab.png

grazitti_sapna
17 - Castor

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

Sapna Gupta
Labels
Top Solution Authors