Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

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