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.
May be like this for your sort expression:
Match(brand, 'B', 'E', 'F', 'A', 'C', 'D', 'Others')
Retrieving data ...