Search
Search

# Sort by sum total

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 Memberreplied

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

0 View this answer in context
View more on this topic or