Re: sorting based on pivot aggregations

2011-01-18 Thread Steve Fuchs
Hello and Thanks for the reply. I've been over that page, and it doesn't seem like it helps with the pivoting aspect. That is if I am sorting via an existing pivot 'sum(student_id,test_grade)' I want my groups of student_id sorted by the sum of test_grade with that student_id. The data is all

Re: sorting based on pivot aggregations

2011-01-18 Thread Ahmet Arslan
> So if my pivot term is:"student_id,test_grade" > I'd want to be able to sort on the number of tests a > student has taken. and also get an average. something like: > :sort => sum( student_id,test_grade )/ count( > student_id,test_grade ) > > where the values would be summed and counted over al