12 Replies Latest reply on Apr 16, 2014 8:34 AM by Dharmesh Purohit

    Need help to define logic for selecting years dynamically

    Dharmesh Purohit

      Hi all,

       

      I need help to build logic  for selecting years dynamically based on current year value.

       

      Problem statement :

       

      I have historical and future data for few years but I don't want to display all the historical years and future years on my chart. My requirement is based on current year I want to generate field which has -2 (historical) years from current year and +5(future) years from the current year.

       

      Can somebody provide me some idea or example of logic how can I do this using Tableau on the fly?

       

      Thanks

      -Dharmesh