How to order table field after a specific value?

[Ferdie]

I recently added an ▲ symbol before the numbers in my 'diff' column. Sorting, however, is not working properly right now. Is it possible for me to let the column ignore the ▲ symbol and just use the numbers after it for ordering it descending/ascending? I know it's possible to just add the ▲ after the numbers, but that looks all over the place if I'm dealing with different lengths of numbers, so I rather have it in front. 

Thanks already

[mfarsln]

Hi,

In the sorting options, set it to 'by expression'. Then sort it by your diff measure expression.

[Ferdie]

Hi there,

I only have two options in the Sorting section:  Nurmeric or Alphabet sorting

[mfarsln]

Can you share sample data?