2 Replies Latest reply on Mar 26, 2014 9:33 AM by Saken Kulkarni

    calculating previous year values

    Saken Kulkarni

      hi all,

       

      I have various methods for calculating the previous year's revenue value, but do you have the best way to do so in Tableau? Let us say you have Revenue for 2011, 2012, and 2013 and you want to calculate last year's revenue. But let us also say that you want to make that dynamic so when it is 2015, you will calculate 2014 as last year...

       

      any advice? do I use datepart?

       

      Saken