I have a crosstab Report That needs the following format

Cost      Commercial     Exchange     Senior
Auth OP     $200.00      $ 0.00      $400.00
ER OP      $500.00      $100.00      $175.00
Auth IP     $ 0.00      $ 0.00      $800.00
ER IP      $ 0.00      $ 0.00      $ 0.00
Total       $700.00      $100.00     $1375.00

The issue is that in Crystal it sorts it Alphabetically. I have a field called sortorder to sort it correctly but since it's a cross tab Report how do I sort it by the sortorder but display the Cost Field