Issue with Filter sorting

[rishimessi19]

Hi

I have a filter with the following values:

I would like the filter to be sorted so  that 'J' is in first value and the rest are sorted in A->Z alphabetical order. As shown below:

I did write an expression in sort tab, but somehow the order is getting reshuffled whenever there is a selection. Note: I did deselect "auto ascending"

Please provide a solution.

[el_aprendiz111]

Hello,

from the script:

[sinanozdemir · Accepted solution]

Hi,

The below is a hackish way of doing it:

Use Dual() function to give "1" to "J".

And then sort as text.

I am sure there is a much better way of doing this.