Derive Corresponding Quarter from Previous Year.

[kishoreravi1983]

Hi Friends,

Plz help me how to calcullate the below metrix.

Metrics to be derived
2017 -Q2	MAX Quarter Always
2016-Q2	Quarter Corresponding to Max Quarter of Previous Year
2017-Q1	Max Quarter - 1
Y/Y %	2017Q2-2016Q2/2016Q2
Q/Q %	2017Q2-2017Q1/2017Q1

Attached the Excel Sheet.

It would be of great help if some one can give me some pointers to it.

Regards,

Ravi