Create a data item in the query with the following statement:
case
when [Priority] = ('High') then 1
when [Priority] = ('Medium High') then 2
when [Priority] = ('Medium') then 3
when [Priority] = ('Medium Low') then 4
when [Priority] = ('Low') then 5
end
This will allow a custom sort on this field that I called "priority number".
John F. Filicetti, PMP, MBA