So I have a table that is showing products on row.
The columns hold an item number, the current inventory and then I have an expression that forecast the sales for coming weeks.
I would like to have a table that subtracts the forecast per week from the current inventory. Like:
| | | | | etc... |
---|
0000-0000-000 | 100 | 90 | 80 | 70 | ... |
0000-0000-001 | 100 | ... | ... | ... | ... |
0000-0000-002 | 100 | ... | ... | ... | ... |
0000-0000-003 | 100 | ... | ... | ... | ... |
So during 2018W41, we're expected to sell 10 units and so the future inventory will be 90 and so forth.
right now I get a table that shows the current inventory for each week (same every time since we only have the current) and then display the forecast next to it. I can subtract the two, but it will just add an extra column. I have also tried to hide a column, but I have to aggregate all the "current inventory" to only be shown at the beginning.
i tried Rangesum and before but cant get it to work..
How can I:
1) Create a table that subtracts continuously from the "current inventory"-column?
2) How can I make it so that column "2018W42" will subtract from "2018W41" and so on?