Yes, that certainly works with the example I gave.
I didn't elaborate in my original post, but the fields I am sorting are manually entered by the user with currency ranges such as:
$2,500 to $24,999
$25,000 to $49,999
$50,000 too $74,999
I wouldn't trust the person entering the data to remember to omit the $ on the first number. If they accidentally added a dollar sign, it will through off the sorting.
As a fool-proof method, what I did was to create two entry fields in the Multi-submit profile.
#1 - A standard text field where they can manually type in the range with the dollar signs. (It won't matter what they type here, because the sort is done on #2.)
#2 - A radio button field where they select the range from a list, and I have entered as:
a- $2,500 to $24,999|b- $25,000 to $49,999|c- $50,000 to $74,999
It works, although it seems there must be a more elegant way to do this.