7 Replies Latest reply on Mar 9, 2017 3:54 PM by Shinichiro Murakami

    Showing last 12 months sales for this year and last year in the same chart

    Sonnie Chen

      I have created a basic line chart, with a relative date filter to show sales for the last 12 months.

       

      Tableau is now showing sales from Feb 2016 to Jan 2017 (Since there is no data for Jan 2017, it will not show up)

       

      Now, I am trying to add one more line in the chart which should show the last 12 months sales, when it was the same time as now in last year.

       

      The new line should show the sales from Feb 2015 to Jan 2016. I am not able to add one more relative filter for this, with one already in the chart.

       

      I have attached a sample work books here.

       

      Can anybody help here?