Unable to lock sort priority order

[Anonymous]

Hi,

I'm attempting to keep my table sorted in a particular way, which is crucial to the presentation of the table.  See attachment 1 for the sort order that I'm trying to achieve.

However, I also have a conditional expression, Major Group, which only appears when there is one brand selected.  As soon as a user clicks on a brand, thus drilling down into the major group field, the sort priority changes! (see attachment 2 for the order that is now in place).  Is there any way I can prevent the sort priority list from jumping around and destroying my table?

Thanks.

[vinieme12 · Accepted solution]

Create an inline table with the sort order for the dimension you want to sort.

Example

Load * inline [

Matches,MatchesSortorder

A,1

B,2

C,3

];

NOW SORT BY EXPRESSION AND use MatchesSortorder