Sorting a dimension

[#1]

I want to sort a dimension in a particular order.

F Account

C Account

R Account

It seems that none of the pre defined Sort by options allow this.

Can someone help with an expression that I can enter to sort in this order?

Thanks

[swuehl · Accepted solution]

Try a sort expression like

=match(DIMENSION, 'F Account','C Account','R Account')

[#3]

Exactly what I wanted. Thank you very much!