QoQ and YoY computation

[satya04]

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?

[gautiergodard · Accepted 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.

[satya04]

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?

[satya04]

@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?