2 Replies Latest reply: Mar 15, 2016 2:46 PM by Jose Luis Barajas RSS

    Comparing day quantities to previous years using a table in Sense.

      Hi:

      I'm having problems trying to solve a problem similar to this.  Giving this data:

       

       

      YEAR-MONTHDAYQTY
      20150110100
      20150115200
      20150120300
      20140105100
      20140115200
      20140120300
      20140130400
      20130105200
      20130110150
      20120120200
      20120122250

       

      Need to get this one if I select YEAR-MONTH = 201501

           

      TOTAL PER DAYTOTAL PER DAYTOTAL DAYTOTALTOTALAVGDIF
      DAYSYEAR-MONTH 201501YEAR-MONTH 201401YEAR-MONTH 2013012 LAST YEARS2 LAST YEARSYEAR 0 - AVG 2 YEARS
      050100200300150-150
      101000150250125-25
      1520020004002000
      20300300200800400-100
      2200250250125-125
      3004000400200-200

       

      Of course if I need to select other year-month previous years are recalculated using 2 previous years and same month.

       

      I'm attaching excel file with data and desired output.

       

      Any ideas?