1 Reply Latest reply on Nov 16, 2016 3:41 AM by Andrew Watson

    Add 5% target on previous year actuals

    gareth.brunsden.0

      I currently have a table that looks like this:

          

      Date
      201420152016
      Profit24,381,01825,049,70622,069,682

       

      I want to create a new measure which gives me results like this:

          

      Date
      201420152016
      Profit24,381,01825,049,70622,069,682
      Target 25,600,06926,302,191

       

       

      Is anyone able to help me create this measure in Tableau? In Excel I am creating the target by adding 5% onto the profit from the previous year (e.g. =C9+(0.05*C9))