3 Replies Latest reply: Feb 3, 2012 1:34 PM by Karl Pover RSS

    Calculate Trend Line

      Hi, I have been trying for weeks to figure this out but still have not succeeded.  I created a chart to show supply and demand side-by-side with weeks as my dimension.  I want to add a trend line to the graph that displays ending inventory from the week before.

       

      The calculation for this week's ending inventory is [Last Week's Ending Inventory] + [Supply] - [Demand].  It seems simple but I can't figure it out.  How would I write the calculation for ending inventory by week? 

       

      Here is a picture of what I am trying to accomplish:

       

      inventory.JPG