I want to build a drop down in the dashboard that contains 3 ways to sort data.
1. alphabetically
2. sorted by value
3.sorted by my own order
For each method, I also need to show a whole list of the filters.
For example, I want to use filter A,B,C to filter the map, then I will need a drop down in the dashboard including 3 options:
alphabetically
sorted by value
sorted by my own order
when I click "alphabetically", it will show
A
B
C
with check box
when I click "my order", it will show
B
C
A
which is the order I manually put in
Hi Ruoxi,
It sounds like you have a lot of pieces you want to get going. I recommend checking out Nested Sorting with Parameter Control to Sort All Rows In Crosstab | Tableau Software which has a calculation that can sort string data alphabetically. If you want to use a parameter to change sort order, than you will want to write a calculation that will return the expected sort order in each scenario.
Hope this helps