Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Subtotals and add % from subtotal

MandyL
6 - Meteoroid

Dear Community,

 

I need your help in adding a subtotal by Customer and then adding % of amount which calculates the % of the project from subtotal of Customer, like the example below (highlighted in bold).

Thanks in advance for your help.

 

Customer

Project

Amount

Subtotal of Customer

% of Amount

Customer A

Project A1

100

200

50%

Customer A

Project A2

100

200

50%

Customer B

Project B1

10

100

10%

Customer B

Project B2

90

100

90%

 

2 REPLIES 2
LordNeilLord
15 - Aurora

Hey @MandyL 

 

A simple summarize tool and formula combo will give you the desired output

 

Capture.PNG

MandyL
6 - Meteoroid

Thank you. It works! 

Labels