Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - Sort By Summary of Group
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Sort By Summary of Group

 Post Reply Post Reply
Author
Message
Shragel View Drop Down
Groupie
Groupie


Joined: 15 May 2006
Status: Offline
Points: 47
Post Options Post Options   Thanks (0) Thanks(0)   Quote Shragel Quote  Post ReplyReply Direct Link To This Post Topic: Sort By Summary of Group
    Posted: 19 March 2015 at 2:15pm
Is there a way to sort by the summary of the group.

For example we are grouping by state and want the group to sort based on the state that has the most orders.
Back to Top
olebed View Drop Down
Admin Group
Admin Group


Joined: 01 July 2014
Location: Ukraine
Status: Offline
Points: 841
Post Options Post Options   Thanks (0) Thanks(0)   Quote olebed Quote  Post ReplyReply Direct Link To This Post Posted: 20 March 2015 at 4:21pm
Hello Shragel,

You can
1) add new auxiliary column with sum of orders
2) calc sum for every state and write it into auxiliary column.
3) group by this auxiliary column.

state orders sum orders of state
1 1 6
1 2 6
1 3 6
2 4 15
2 5 15
2 6 15

state orders
sum orders of state: 15
2 4
2 5
2 6
sum orders of state: 6
1 1
1 2
1 3


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.156 seconds.