How to sum fieds of collapsed results?

I need to do a sum aggregation on a collapsed result. I know that collapse does not effect on aggregation but there are other ways?

For example:

  • Field1 = A, Field2 = 50, Order = 1
  • Field1 = A, Field2 = 30, Order = 2
  • Field1 = B, Field2 = 20, Order = 1

My query is ordered by "Order" and collapsed on "Field1", then I want to sum "Field2" of the collapsed result to obtain, in this case, the value 70.

Is it possible?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.