14 Replies Latest reply: Jul 14, 2016 1:35 PM by Estéfano Barrera RSS

    Average of sales por month

    Estéfano Barrera

      Hello friends,

       

      I need your help. I need show average of sales por month. But the average have that considerate the month and 11 month ago. Dimension is month of year 2015

       

       

      YearMonthSales(Uni)
      20141120
      20142130
      20143150
      2014480
      2014590
      20146100
      20147110
      20148140
      20149130
      201410160
      201411170
      201412180
      20151130
      20152150
      20153140
      20154110
      2015580
      20156110
      20157140
      20158120
      20159140
      201510180
      201511200
      201512210

       

      Expected Result:

      JanFebMarAprilMayJuneJulyAguSepOctNovDec
      131133132134133134137135136138140143

       

       

      thanks for your help