I've built a pivot that displays a starting inventory value (row) and associated future sales orders by day (columns).
Using the calculated field feature (excel 2013), I can show the remaining inventory on any day specific to the inventory base.
However, what I'm really trying to do is display the progressive decrease of the inventory over time against that base as new orders are added.
Here's an example:
Inventory (row):1000 units
Orders by date (columns):
Day 1 : 300 units
Day 2 : 250 units
Day 3 : 275 units
Day 4 : 250 units
Ideal result:
Day 1 Day 2 Day 3 Day 4
Inventory (base) 1000 700 450 175 -75
Is this possible with a pivot?
Using the calculated field feature (excel 2013), I can show the remaining inventory on any day specific to the inventory base.
However, what I'm really trying to do is display the progressive decrease of the inventory over time against that base as new orders are added.
Here's an example:
Inventory (row):1000 units
Orders by date (columns):
Day 1 : 300 units
Day 2 : 250 units
Day 3 : 275 units
Day 4 : 250 units
Ideal result:
Day 1 Day 2 Day 3 Day 4
Inventory (base) 1000 700 450 175 -75
Is this possible with a pivot?
