6 Replies Latest reply on Jul 5, 2016 3:44 AM by Sankarmagesh Rajan

    Lookup / Previous_Value / Table Calculations

    Joe Bend




      Fairly new to Tableau, so any help appreciated on this!!


      So, here I am trying to achieve stock for week 28 on-wards.


      Stock for week 28 is a calculation of Stock (from previous week) + Production - Forecast


      In essence, the excel calculation of this:


      Please note each of these come from different data sources.

      So far I am able to calculate the first week (Week 28) using a lookup. However I was expecting this to continue to calculate across all weeks?