I would create a custom query and then add a case statement so create a sort field
select nodeid, caption, statusdescription,
case when status=1 then 4 when status=2 then 1 else status end AS [sort]
sort by [sort] desc
status integer to your needs are not reflected above.
Not sure if the above could be done with the custom table report resource without needing custom swql or sql.
never tried to case values with it.