I have a field called Rack which has the values as Rack-1 Rack-2 Rack-3....Rack-10. When I do sort on Rack field, it shows the values like below :
Rack-1 Rack-10 Rack-2 ... ... Rack-9
I want to show the values as : This is the requirement ?
Rack-1 Rack-2 Rack-3 ... ... Rack-10
By default, sort is showing Rack-10 after Rack-1 and then so on. How do I sort it alphanumeric to show the values as required above ?