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?