1 Reply Latest reply on Mar 8, 2017 1:50 PM by Jeff Strauss

    Tableau Functions




      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.


      Thank you,