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

    Lookup / Previous_Value / Table Calculations

    Joe Bend

      Hello,

       

       

      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?

       

      Thanks,
      Joe