|  | 
| Sort By Summary of Group | 
| Post Reply   | 
| Author | |||||||||||||||||||||||||||||||||||||||
| Shragel   Groupie   Joined: 15 May 2006 Status: Offline Points: 48 |  Post Options  Thanks(0)  Quote  Reply  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. | |||||||||||||||||||||||||||||||||||||||
|  | |||||||||||||||||||||||||||||||||||||||
| olebed   Senior Member   Joined: 01 July 2014 Location: Ukraine Status: Offline Points: 841 |  Post Options  Thanks(0)  Quote  Reply  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. 
 
 | |||||||||||||||||||||||||||||||||||||||
|  | |||||||||||||||||||||||||||||||||||||||
| Post Reply   | |
| Tweet | 
| Forum Jump | Forum Permissions  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |