I would need to calculate YoY and QoQ change for data which is in the following format. Can you please guide me on how this can be done?
Solved! Go to Solution.
Hey @satya04
You can do something like the attached if you want to keep the data structure unchanged.
I've done the calc using CapEx as an example.
Hello @gautiergodard records till CQ122013 may not have YoY due to unavailability of prior period. Can you please help me understand the logic for obtaining the calculation here?
@gautiergodard The result coming in the first row of YoY CapEx should come on the 5th row (Row+4). Can you please guide me on how it can be done?