Cannot make sort take precedence over group

[cosito]

I need to display a report as follows

Region A:
Account Amount
DDDD 125
DDDD 125 (//This is a total of 250 therefore DDDD 1st)
CCCC 210
BBBB 205

Region B:
.......
.......
The report must be grouped by region and then grouped by account but sorted by total amount for each account.
I can create the first two groups but cannot seem to sort
on Amount. Any direction??? Thank you

 

[lbass]

It looks like you are trying to display detail records instead of the group 2 (account) totals. To get the sort you want, insert a sum on {table.amount}. Then go to report->topN/sort group expert and choose the sum to sort by in descending order. It looks like you already have the group 2 header and footer suppressed, so that only details are displayed, so that should do it.

-LB