Print Page | Close Window

Sort by Sum of Group

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=703
Printed Date: 04 May 2025 at 6:23pm


Topic: Sort by Sum of Group
Posted By: ode2eba
Subject: Sort by Sum of Group
Date Posted: 20 May 2007 at 11:36pm
Hi all,
 
Let's take these data for example (grouped by Category)
 
Category                         Sales ($)
 
Category 1
    Item AAA                           100
    Item BBB                             50
    Item CCC                            30
Subtotal                                180
 
Category 2
    Item DDD                          200
    Item EEE                           100
    Item FFF                             50
Subtotal                                350
 
Is there any way that I can sort data based on Category subtotal, showing most sales on top (i.e Category 2 on top followed by Category 1)
 
Need help, thank you in advance


Replies:
Posted By: GuestX
Date Posted: 22 May 2007 at 5:48pm
Make new sql command that will SUM sales on each Category then use that data as group. no?


Print Page | Close Window