Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
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%

 

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