4 Replies Latest reply on Jun 28, 2013 9:42 AM by siddhartha.siddhartha

    Quarter over quarter calculation

    siddhartha.siddhartha

      Hi All

       

      The issue i am facing is I have to calculate quarter over quarter % difference for spend.

      for example in the data for all the first quarter over years which are 2010Q1 , 2011Q1, 2012Q1 and 2013Q1., i need to calculate percentage difference for the same quarter from the previous year.

       

      I have done that and its working fine.

      The problem i am facing is that how to show last 5 quarters but still have the above calculation.

       

      Please find attached the sample workbook and advice.

       

      Thanks