2 Replies Latest reply on Jul 27, 2016 11:27 PM by Biju J

    How to do a running difference

    Biju J

      My data is like this and I need the third column as below defined.

       

      Yearvalue
      running diff
      20151000
      201612001200-1000/1000=.2*100= 20%
      201715001500-1200/1500=.3*100=30%
      201822002200-1500/2200=.7*100=70%

       

       

      I tried tableau default table calculation using percent from  but it does the calculation like

      1200-1000/1200=.16*100=1.6%

       

      Is there any other way to change the behaviour as the one I required.

       

      Thanks

      Biju