sort filter pane field based on another data field

[ioannaiogr]

Hello everyone 🙂

My question today is the following:

I want to sort numerically  in my filter pane the field WholeYear ( with values 2001-2002, 2002-2003 etc ) by its corresponding field WholeYearNum (with values 1,2,3, etc). Is that possible?

Thank you in advance!

[snibrahim1993 · Accepted solution]

Hi @ioannaiogr 
Try the below

In the "Sort by Expression" section, enter the following expression:

=Num(WholeYearNum)

[ioannaiogr]

Thank you 😁 @snibrahim1993