cal % in multiple columns with multiple totals

[chenyzhao]

Hello - i'm trying to do a % cal in multile columns. The original data looks like below, it was grouped by fund and then investor. I need to calculate the % for each quarter for each fund. I played around with summary too to get the fund total, and then Join tool to join the source and total together. But I could not figure out how to do formula for each quarter. Thanks!

Fund	Investor	2021 Q1	2021 Q2	2021 Q3	2021 Q4
A	Allen	100	150	180	200
A	Mark	100	150	180	200
A	Tom	100	150	180	200
B	Scott	200	250	280	300
B	Mary	200	250	280	300
B	Alice	200	250	280	300
C	Joe	300	350	380	400
C	Aly	300	350	380	400
C	Ashley	300	350	380	400

The desired out would be like below. 

Fund	Investor	2021 Q1	% of Q1	2021 Q2		2021 Q3		2021 Q4
A	Allen	100	33.33%	150	33.33%	180	33.33%	200	33.33%
A	Mark	100	33.33%	150	33.33%	180	33.33%	200	33.33%
A	Tom	100	33.33%	150	33.33%	180	33.33%	200	33.33%
Total		300		450		540		600
B	Scott	200	33.33%	250	33.33%	280	33.33%	300	33.33%
B	Mary	200	33.33%	250	33.33%	280	33.33%	300	33.33%
B	Alice	200	33.33%	250	33.33%	280	33.33%	300	33.33%
Total		600		750		840		900
C	Joe	300	33.33%	350	33.33%	380	33.33%	400	33.33%
C	Aly	300	33.33%	350	33.33%	380	33.33%	400	33.33%
C	Ashley	300	33.33%	350	33.33%	380	33.33%	400	33.33%
Total		900		1050		1140		1200

[Felipe_Ribeir0 · Accepted solution]

Hi @chenyzhao 

One way of doing this:

[chenyzhao]

thanks, very helpful!