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.

If I'm understanding your question correctly, here is an option. I created a new Sort on... parameter with values "Current Year," "Last Year" and "First Year" and used that in the Sorting Column calculated field instead. Now, when you select "Current Year," it will automatically sort on the sales values from the maximum order date year. "Last Year" causes it to sort on the year before the maximum order date year, and "First Year" causes it to sort on the minimum order date year.

This way, the field will automatically ignore any records whose Order Date year is greater than the current year (2016). The other advantage to using the calculated field in this way is that, once 2017 does eventually roll around, it will treat 2017 as the current year.