Subtotals and add % from subtotal

[MandyL]

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%

[LordNeilLord · Accepted solution]

Hey @MandyL 

A simple summarize tool and formula combo will give you the desired output

[MandyL]

Thank you. It works!