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?