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: