I have weeks: 1,2,3,4 and I have ending inventory.
week: 1 2 3 4
end inv: 10 15 16 17
How would I create a new variable: beginning inventory which is equal to the ending inventory from the previous week.
For example my end inventory at week 2 was 15 so my beginning inventory at week 3 should equal 15. What formula do I use in order to create beginning inventory measure.
you can try to use a lookup function.
LOOKUP(sum([End Inventory]),-1 )
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...