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.

       

      Regards,

      Ravi