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