I've setup a text table which will be shared with other users, and I want the table to auto-sort based on a specific measure, but also give users the ability to sort by other columns if they wish. Is this possible using my data set?
Additionally, as users choose other Dimensions from the filter, I would like the sort to be persistent, which I don't believe it currently does.
10 answers
It is possible. You can create 2 additional calculated fields for sorting based on the measures 2 and 3, and put them beside the initial discrete sort order calculated fields. I have attached a sample workbook. Hope it helps.
