Maybe you could sort ascending first, then select just the non-"N/A" rows and
sort them descending.

"Conrad C." wrote:

Is there anyway to change to default sort order? I am trying to sort in a
list percentage change from prior year, but in the case when there is no
prior year information the display is "N/A", which is fine, but I need it
sorted to the bottom of the list when I sort descending. Is there anyway to
sort this to the bottom?