Sorting by summary fields

[Andy_]

I have a sales report in preview mode.

I have a summary field showing sub-totals, I would like the report sorted by this field so that the higher sales figures sit at the top of the report.

When I look at my report in preview mode it is sorted by product, I have to click 'sort' then the checkbox to include summary fields, then move the summary sub total field into the right hand field list, then click 'descending order', then click 'sort'.

Question is - How can I automate this? Surely it must be possible

Thanks for any help

[RalphL]

Preform the sort, then write a script using the sort command. The script will remember the sort.