Sorting on calculated field

[tango]

Hi,

I have a calculated field Type in front end and I want to sort it order of Z, O, P ,Q .

The process of sorting from Property panel will not work as type field is created in front end . 

Need help. 

Thanks!

[G3S]

have you tried the 'match' expression in the sorting?

=match((YourFieldCalculation), 'Z', 'O', 'P' ,'Q')

[tango]

I m unable to call that field as it is created in Front end , that's
causing an issue while performing pick and match .

[G3S]

instead of the field add the expression used to create the field.