4 Replies Latest reply on Sep 23, 2016 8:48 AM by Benjamin Greene

    option for user to Sort Date Dynamically based on Year - Dynamic Sorting

    Prasanna Selvaraju

      Hi Tableau Guys,

       

      I would like to solve a use case on sorting list of Vendors Name based on year.
      As of now , solution I got is using Parameter Value ( like Year(Date) = Parameter.Value (eg: 2014 ) THEN SUM(Sales)

       

      But as you all aware once the data is change value of parameter wont change. I have attached a dashboard.

       

      Objective  : I need option for user , like in dashboard 2010 , 2011 , 2012 etc dynamically may be like current year & value , Last year & value and dashboard should sort based on that selection . Eg : Current Year.

       

      Refer Dashboard attached for year over year sorting.