This is an interesting idea, Kajal.
There is one shortfall I noticed using this method.
When I added YEAR to the "Top N States" tab, I clicked the sort descend button, and noticed the set did not update when I selected Year = 2012. Below is an example of this:
Ultimately I would like to able to sort each fiscal quarter when "quarter" is selected on the the Select Date Level parameter, and would like to sort each month when "month" is selected on the the Select Date Level parameter. Any other ideas on how to accomplish this?
in this case, when you are putting year on filter and only focusing on 2012,
Please do the following : Put Year(order date) on filter shelf
Right click on it and then Add to context.
It will give you the desired result with proper sort.