Difficult to say without twbx file although I do have one post for you as ---> Creating a Parameter Control to Sort By Dimension | Tableau Software
See if it helps or kindly post a twbx file.
Slogger Blogger at tableauinfo.com
Thank you very much for your help, and my apologies for my late reply.
I have attached the Tableau workbook. It will indeed be easier to understand.
Basically, this dashboard gives a lot of filtering possibilities to the user.
In addition to the main filters on the top, I have added two parameters:
1. " Choose a view" to allow the user to see by hotel, cities, etc.
2. Choose a metric view, to allow the user to see different metrics whether in % or in $.
The issue that I face is that is I choose a metric view other than Total F&B Sales - vs. LY %, I can't sort my months from the largest to smallest or smallest to largest anymore. It works only with this metric.
I am not sure why, but I really need to have this capability for any metric that is chosen.
Ex: If I want to rank my best performers for oct. I can't to that...
1 of 1 people found this helpful
Sorting in tableau works based on the Grand Total of the measure by which you would like to Sort the Data. In such a case you would need to create different sheets for each month and allow people to Sort the data for that particular month in the respective sheet. However that sort will not effect or change the other months sheet.