Hi. I have a dimension in a pivot table called Label.
The values of the labels are text strings. There are 5 of them.
'Very Big Label'
'Medium Big Label'
The people I am building the report for always want to see the labels in this order. I can't sort by Text, or Load order, or frequency, so I am wondering if I can create a custom expression to sort them in this order. But I am not very good with the expression language. Can anyone help me write an expression which will sort them in the correct way?
this Match expression works great to sort my list box content being "red", "yellow", "green".
However, as soon as I select a value, this value is moved to the bottom of the list which is quite confusing for the user. How do I keep it from moving when I select?
somehow I got it to work, but I don't know how. The "sort by state" option is actually disabled at this moment. See below. Perhaps that is triggered by some other setting. But now I know what that option is doing - thanks 🙂