2 Replies Latest reply on Aug 26, 2016 7:49 AM by Michael Hesser

    Table Calculations  in tableau based on lookup functions

    dinesh reddy

      hi,

       

      i am trying to do some calculations in tableau

       

      Uniquenew1balancenewpercentO/P
      2003001-0.1270
      2003002-0.1243
      20030030.9461.7
      20030041.91338.93
      2003005-0.11205.037

       

      i want o/p column in tableau

      calculation used is for first row it will be = (300*(1+(-0.1))

      and for second row is i need to use the output for first row instead of 300 i.e (270*(1+(-0.1))

      like that it repeat.

       

      thanks,

      Dinesh