Sort by sum total

[Former Member]

Hello,

I need help on the following:

A table (generated from XML) contains the following:

Customer \ Sales Order Number \ Sales Order Line \ Ext Price

For example:

A Customer \ 5000 \ 1 \ 250

A Customer \ 5000 \ 2 \ 300

B Customer \ 5001 \ 1 \ 200

B Customer \ 5001 \ 2 \ 50

My problem:

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.

[Former Member · Accepted solution]

Hi Michael,

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,

-Cyndi

[Former Member · Accepted solution]

Hello Cyndi,

This has solved the problem, thank you very much.

Michael