I am facing a challenge to calculate the below information:
Requirement was :
Issue 1 :I can able to calculate the a, b, c in different sheets(PFA workbook).(How I have achieved: each sheet I have changed the snapshot month filter based on the requirement). But as per the requirement we should display everything in single sheet
Issue 2 : I am unable to get the % calculation due to changing the snapshot date filter based on requirement for each RAG.
Thanks in advance.