Sort Filter by combined value

[Ronald]

Hello good day
I would like to sort desc the filter by year, but it doesn't sort:

Q1 2020

Q2 2020

Q3 2020

Q4 2020

Q1 2019

Regards.

[Fernando_Fabregas]

Hi Ronald. 

In order options, choose "By expression", Descending, and put this formula: 

Right(YourField,4) & Left(YourField,2)

Regards !

[Ronald]

Sorry don´t work

[Fernando_Fabregas]

You are right, I don't know why sorting strings not always works fine...

Try this:

    Right(YourField,4) & Mid(YourField,2,1)

In this way you'll sort numbers and it works well for me.