Aggregation on multiple columns

[sriniprad08]

Hi Team,

I need help. Please find below the sample. 

C Category	Category	2018-01	2018-02	2018-03
A	AC	322,165	304,638	299,908
B	AC	461,108	409,994	779,603
C	AC	1,449,944	1,751,532	1,763,404
D	AC	21,215	23,787	26,406
A	BC	310,499	310,499	316,931
B	BC	426,705	426,705	426,705
C	BC	1,362,659	1,362,659	1,362,659
D	BC	24,755	24,755	24,755

the output will be- The calcuation is (AC/BC) for each C category. 

OUTPUT
C Category	2018-01	2018-02	2018-03
A	1.037573	0.981124	0.946288
B	1.080625	0.960837	1.827029
C	1.064055	1.285378	1.294091
D	0.85701	0.960905	1.066685

thanks for the help in advance

[jamielaird]

Hi again @sriniprad08 ,

The screen recording below gives an example of how to turn this process into a macro:

https://www.screencast.com/t/szjwI7qJL2

[sriniprad08]

Hi @jamielaird ,

Thank you so much. sure will go through it.

Cheers,