Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Ronald.
In order options, choose "By expression", Descending, and put this formula:
Right(YourField,4) & Left(YourField,2)
Regards !
Sorry don´t work
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.