8 Replies Latest reply: Apr 13, 2012 9:27 AM by stieneke RSS

Custom Sort By Expression


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'

'Small Label'

'Default Label'

'Insignificant 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?