4 Replies Latest reply: Nov 9, 2011 7:47 AM by Fred Schonenberg RSS

    Partial Accumulation in Graph

    Fred Schonenberg

      Hi,

       

      I guess it's just a small question:
      For Stockmanagement I need to present current stock values and future stock values based on known changes. I know the current Stock values and the changes.

       

      What I need is a graph with the current Stock value as startingpoint and the changes accumulated per week.

       

      For example:
      0. Current value = 20
      1. 201146 (next week) = +10 (in)
      2. 201147 (next week) = -5 (out)
      3. 201148 (next week) = -14 (out)

       

      The Graph for this example needs to have three Bars:
      week 201146 - Stockvalue = 30 (20 + 10)
      week 201147 - Stockvalue = 25 (30 - 5)
      week 201148 - Stockvalue = 11 (25 - 14)

       

      The problem is the need to accumulate the changes without accumulating the current value.

       

      Anyone?
      (example file attached)

       

      Thanks in advance.