5 Replies Latest reply on Nov 19, 2014 10:17 AM by Matt Lutton

    Calculating Difference Between Years

    Thomas Whitaker

      Hi, new to tableau. I am hoping this is straightforward ...

       

      My excel data that I connect in tableau looks like this:

       

      ProductSalesYear to date
      A£50031/122009
      A£75031/12/2010
      A£100031/12/2011
      B£80031/12/2009
      B£70031/12/2010
      B£10031/12/2011
      And so on

       

      I can use the year to date column to produce line graphs and tables which I can then filter by product - great!

       

      What I need to be able to do is calculate the actual difference in sales between the years - how can I do this if the years are in the same variable?

       

      Thanks in advance,

      T