Custom Sort not working

[mahendragaur]

I am trying below expression to custom sort value but it is not working. Any suggestion please

Match(Dim,'Car','Bus','Plane','Boat')

[anushree1]

Hi,

Please check the attachment, it seems to work for me

[vijetas42]

=Match(Dim,'Car','Bus','Plane','Boat')this should work if not, you can use if condition like below,

if(Dim='Car',1,if(Dim='Bus',2,if(Dim='Plane',3,if(Dim='Boat',4))))

Regards,

Vijeta