Sorting by Totals Column

I need to generate a report that is sorted by the amount generated in a Totaled column. The view has only two fields. Field 1 is a catergoriezed field and field 2 is an number field that is totaled.

I need to be able to generate a report that is sorted by the totaled field. I understand that you can not accomplish this natively in the view, but is there a way around this limitation?

Thank you for any insight.

Shawn~

Subject: Sorting by Totals Column

Could you clarify? Are you trying to sort by field 2 within a catehgory or by the category totals themselves?