Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Subtotals and add % from subtotal

Highlighted
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%

 

Highlighted
Alteryx Certified Partner

Hey @MandyL 

 

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

 

Capture.PNG

Highlighted
Meteoroid

Thank you. It works! 

Labels