Hi I am using pivots extensively in my search,and they work well for searching and displaying. But I find the need to be able to sort by the sum of a certain pivot, after it is collapsed.
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 all of the entries where student_id was the same. It doesn't seem to be working now, but does seem like a feature people would like. Is there any plan to implement it? Or even better a patch that I could apply? thanks in advance steve
