thank you for your fast reply and sorry, i didn´t exactly understand.
In the example data set, there can be a lot of orders with counter 4. Therefore i thought to use sum(aggr... ) formula. e.g.:
Counter | Value
4 | 100
(100 -> 10(A) + 30 (F) + 50(G) + 10(Z))
how can is use expressions max(counter) and max(value) as you described? Follwing formula is not working:
sum ( aggr ( max (Value) and max(Counter),Order ))