Add % from subtotal

[DAM]

Dear Community,

I need help in adding a % column, which calculates the % of the row from its subtotal (the bold are subtotals), like in the example:

SR	Sales	%
A	100	100%
A	100	100%
C	20	20%
C	30	30%
C	50	50%
C	100	100%
E	20	50%
E	20	50%
E	40	100%

Thank you in advance for help.

[LordNeilLord · Accepted solution]

Good morning @DAM,

Using the summarize tool, group by SR to return the Max_Sales (the subtotal)...join this back into your main workflow and use this to calculate your %

[DAM]

Thank you for quick response. Very useful.