Custom Sort order

[shanky1907]

Hello All,

I want to implement a custom sort order for my dimension brand.

For ex. i have values in the dimension like A,B,C,D,E,F,Others.

So i want to sort them in an order like B,E,F,A,C,D,Others at last.

How can i achieve this through sorting.

Please share your helpful reviews.

[sunny_talwar]

May be like this for your sort expression:

Match(brand, 'B', 'E', 'F', 'A', 'C', 'D', 'Others')