Calculating sum total and percentage

[SCK]

Hello all - I need another help. I need to calculate total of the dataset and then percentage of total only for a dataset with over 100 clients together. Please help.

Input:

Client	Client Number	Data	Data1	Data2
A	1	Cash	3	50
A	1	Accounts Payable	4	110
A	1	Accounts Receivable	5	250
A	1	Inventory & COGS	6	200
B	2	Cash	7	150
B	2	Accounts Payable	8	85
B	2	Accounts Receivable	9	90
B	2	Inventory & COGS	10	110

Output:

Client	Client Number	Data	Data1	Data2	Ratio
A	1	Cash	3	50
A	1	Accounts Payable	4	110
A	1	Accounts Receivable	5	250
A	1	Inventory & COGS	6	200
A	1	Total	18	610	0.029508197
B	2	Cash	7	150
B	2	Accounts Payable	8	85
B	2	Accounts Receivable	9	90
B	2	Inventory & COGS	10	110
B	2	Total	70	1655	0.042296073

[Assaf_m]

Check the attached solution,

let me know if it works for you