1 Reply Latest reply on Jun 29, 2016 4:19 PM by swaroop.gantela

    Rolling Calculation in Linear Model using Calculated Field

    Wan Theng

      Hello,

       

      I am creating a linear model, however there is a rolling calculation in one of the variables.

      For example the result of the previous row is used as a variable for the next row.

      I've included an image to make explanations and understanding easier.

       

      I would like to know if there are any tableau functions that i could use that i unaware of?

       

      I was thinking of PREVIOUS_VALUE, however, am not entirely sure on how it can be applied here.

       

      Thank you.