Help with Context Formula in calculating percentage

[rajua99]

Hello Team,

In my report i need to calculate Percentage based on Revenue for each row by year-month.

from the below data for Rock & sand for year month 2022-03 i need to divide that row with Revenue row i.e 99,816.66/2,032,952 and calculate the percentage.

HECTOR M MICHEL   ROCK & SAND                                                  2022-03           99,816.99      
HECTOR M MICHEL   REVENUE CONCRETE                                     2022-03      2,032,952   


Do the similar for other rows based on Year - month for each cost type description.

Can you please help me how to create formula by keeping context in place so that the % is calculated properly.



Thanks,
Raju