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|
Attached the Excel Sheet.
It would be of great help if some one can give me some pointers to it.