This content has been marked as final. Show 8 replies
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?