On 2016-02-20 15:24, Tracy Pearson wrote:
When you have an aggregate (the sum), you should group by all the noon-aggregate fields.
You could use the numbers for each field. Group by 3,1,2,4,5,6
I've often thought: the order of your GROUPING doesn't matter....does it? Either way, it's the same distinct combination.