Help in sorting

[ashmitp869]

Hi All,

I am using a filter with text field but the values is below -

How to sort it by year wise.

[Lisa_P · Accepted solution]

If you sort by Text it should be correct.

[vinieme12]

Sort by text as suggested by @Lisa_P 

OR

sort by expression as

=aggr( subfield(FiscalYear,'/',1),FiscalYear)