Alteryx designer Discussions

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

Subtotals and add % from subtotal

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

 

Highlighted
Alteryx Certified Partner

Hey @MandyL 

 

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

 

Capture.PNG

Highlighted
6 - Meteoroid

Thank you. It works! 

Labels