2 Replies Latest reply on Aug 2, 2017 11:51 PM by florin fm

    How to find previous value

    florin fm

      Hello,

       

      I have the following data:

         

      IdRankValue
      15125
      15260
      15347
      15410
      2018
      20215

       

      I need a calculated field for the 'Previous Rank Value' for the same Id:

       

          

      IdRankValuePrevious Rank Value
      15125null
      1526025
      1534760
      1541047
      2018null
      202158

       

      Can you please help me with a formula for the calculated field 'Previous Rank Value' in Tableau 9?

      Thanks!