% of a Subtotal formula

Question

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%A11010%A22020%A33030%A44040%A Total100100%   B14040%B26060%B Total100100%

alexnajm · Accepted Answer

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 Answer

Like so?

abacon · Accepted Answer

@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