How to change sort priority of dimension in a straight table using a button
I have a straight table with two dimensions and rest are expressions.
In the properties --> Sort tab, I can promote or demote a dimension and decide its priority.
Is it possible to achieve the same externally, like through a click of a button ?
Double clicking on header (Interactive Sort) does that for one chart, but need is to have all the charts sorted with same primary sort dimension with a single click.
I created a button which reads and sets a variable value, and changes its label. But don't know how to use this variable for above requirement.
My recommendation is to sort on the same dimension each time, but change it to sort 'by expression'.
The expression is an IF statement that reads the variable and assigns a different expression like sum(Sales) or CustomerID depending on what the user selects.
.png "Former Employee"){kind=icon}
