% of a Subtotal formula

[joeltran]

hi All,

How do I create this % formula in Alteryx please. I have been stuck. I have created a sub total amount with the formula for product A and B. 

Many thanks

Joel

Product	Amount	%
A1	10	10%
A2	20	20%
A3	30	30%
A4	40	40%
A Total	100	100%
B1	40	40%
B2	60	60%
B Total	100	100%

[alexnajm · Accepted solution]

Append a sum of all the amounts (except total) to each line item and use a Formula to calculate the percentage!

Here's a version of what I'm saying in case you have your data per product too: Solved: Calculating % of Total - Alteryx Community

[caltang · Accepted solution]

Like so?

[abacon · Accepted solution]

@joeltran I would get the summarize at the top level (so A and B) in one branch. Once I have done this, I would join total back to the main data stream, from there you can do a percentage calculation to get the desired numbers. See screenshot below along with the attached workflow.

Bacon