6 Replies Latest reply: Jun 24, 2013 2:35 AM by test test RSS

    Handle Zero Values in Month Dimension

      I have the following table which shows the sum of stock for each article, in that specific month.

       

      Month MF  10 10 MF  10 13 MF  10 15 MF  10 18 MF  10 20 MF  10 25 MF  10 30 MF  10 35 MF  10 40 MF  10 45 MF  10 50
      jan 21 33 12 63 36 0 13 10 0 3 0
      feb 14 27 35 51 32 38 11 8 0 0 0
      mrt 12 25 70 0 20 60 23 0 0 0 0
      apr 77 0 28 38 45 48 10 10 0 0 0
      mei 0 0 114 35 60 37 0 8 1 0 0
      jun 70 20 111 34 38 62 7 8 1 3 3

       

      I want to accomplish this:

       

      MonthMF 10 10MF 10 13MF 10 15MF 10 18MF 10 20MF 10 25MF 10 30MF 10 35MF 10 40MF 10 45MF 10 50
      jan2133126336??1310??3??
      feb142735513238118030
      mrt122570512060238030
      apr7725283845481010030
      mei7725114356037108130
      jun702011134386278133

       

      ofcourse in the example the ?? values will be subtracted from december the previous year.

       

      How can i accomplish this?