5 Replies Latest reply on Feb 23, 2016 4:37 AM by Justus Niemzok

    Comparing different periods on same data

    keerthana kumar

      I am trying to achieve

      Year 2014 Over Year 2013

      QTR1 2014 over QTR1 2013

      similarly month too

       

      I was able to achieve Qtr1 2014 data and Qtr2 2014 data but not able to do a growth comparison on this. its giving me blank value

      Please find the attached workbook for reference

       

      TY : Sum(value)

      LY: LOOKUP(sum([value]),-1)

      so to lookup LY qtr value i gave the below calculation

      table calculation.png

       

      How to derive Growth basically Ty -Ly??