7 Replies Latest reply on Apr 14, 2017 2:07 PM by Norbert Maijoor

    Show Year and (Year - 1)

    Wendy Lin

      Hi all,


      I'm working with a chart in Tableau that shows head count from the current year and one year before (for instance, 2017 and 2016). 


      I ran into a problem because I need a filter or a parameter for the user to select the year they want to view the data for, even though it defaults to cur_year.


      For instance, if they select 2016, the chart should show 2016 and the year before, which is 2015. 

      If they select 2015, the chart should show 2015 and 2014 data.


      How can I accomplish this?  Thanks so much for your help.