Add % from subtotal

Question

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:

SRSales%A100100%A100100%C2020%C3030%C5050%C100100%E2050%E2050%E40100%

Thank you in advance for help.

LordNeilLord · Accepted Answer

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 %