0 Replies Latest reply: Mar 17, 2017 3:25 AM by Ravi Kishore RSS

    Derive Corresponding Quarter from Previous Year.

    Ravi Kishore

      Hi Friends,


      Plz help me how to calcullate the below metrix.


      Metrics to be derived
      2017 -Q2 MAX Quarter Always
      2016-Q2Quarter Corresponding to Max Quarter of Previous Year
      2017-Q1Max 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.