http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 02 May 2026 00:47:55 +0000 Fri, 20 Mar 2015 16:21:09 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=22560 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=22560&PID=73160&title=sort-by-summary-of-group#73160 Author: olebed
Subject: 22560
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

]]> Fri, 20 Mar 2015 16:21:09 +0000 http://forum.codejock.com/forum_posts.asp?TID=22560&PID=73160&title=sort-by-summary-of-group#73160 http://forum.codejock.com/forum_posts.asp?TID=22560&PID=73158&title=sort-by-summary-of-group#73158 Author: Shragel
Subject: 22560
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.
]]> Thu, 19 Mar 2015 14:15:39 +0000 http://forum.codejock.com/forum_posts.asp?TID=22560&PID=73158&title=sort-by-summary-of-group#73158