2 Replies Latest reply: Jun 21, 2013 3:20 AM by test test RSS

    Make a Sum of an Expression

      I have the following expression:

       

      =FirstSortedValue(PartStockEnd, -Date)

       

      It gives me the following results: (with PartStockEnd as a value, which is the stock at the end of that month)


      Month Article 1Article 2Article 3Article 4Article 5
      jan 21 33 12 63 36
      feb 14 27 35 51 32
      mrt 12 25 70 0 20
      apr 77 0 28 38 45
      may0 0 114 35 60
      jun 70 20 111 34 38


       

      Which is correct. I can display this and a chart and everything is fine.

       

      But now I want to have a sum of the stock for each month, so I can see the total stock over the last months. How can I accomplish this?