Sort by sum total
I need help on the following:
A table (generated from XML) contains the following:
Customer \ Sales Order Number \ Sales Order Line \ Ext Price
A Customer \ 5000 \ 1 \ 250
A Customer \ 5000 \ 2 \ 300
B Customer \ 5001 \ 1 \ 200
B Customer \ 5001 \ 2 \ 50
However, I need to show it descending by the total of ext price for each order:
A Customer \ 5000\ 550
B Customer \ 5001 \ 250
Problem is, I group by Order Num, then sum the Ext Price to get the total for each order. However, because the Order Num is grouped first, how do I then tell Crystal to actaully sort overall in descending value by the sum of the ext price?
Any help is most welcome.
Try selecting Report for the menu bar and then select Group Sort Expert. You should then see any groups you have. Select Order number group and then under "For this group sort" select "All" and then under 'based on" select sum of Ext. Price. You can then click Descending.
Hope that helps,