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?
- 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?