3 Replies Latest reply: Jul 8, 2016 11:17 AM by Sunny Talwar RSS

    current &Previous yr quarterly sales in the same table

    Mike Anand

      Hi all,

       

      Reference the table below:

      I want to add the 4th Column "Last yr same qtr sales" which will show the sales of the qtr but previous year.

       

      Any Idea what would be the code for this?

        

      YearQuarterSalesLast yr same qtr sales
      2012Q19665x
      2012Q22750x
      2012Q32191x
      2012Q43316x
      2013Q12656x
      2013Q22338x
      2013Q37551x
      2013Q45173x
      2014Q13360x
      2014Q26958x
      2014Q38052x
      2014Q44819x
      2015Q136333360
      2015Q218906958
      2015Q376658052
      2015Q450554819

       

       

      Thanks in advance.

      Mike