This content has been marked as final.
Show 2 replies

Re: AGGR Function Problems with 2 expressions or 2 dimensions
Gysbert Wassenaar Jul 9, 2013 12:21 PM (in response to Steffen Hasenkopf )Use Order as dimension and as expressions max(Counter) and max(Value). You don't need the aggr function since you're using only one aggregation function. Because Order is used as dimension the expressions will be aggregated for A, B and C.

Re: AGGR Function Problems with 2 expressions or 2 dimensions
Steffen Hasenkopf Jul 10, 2013 3:03 AM (in response to Gysbert Wassenaar )Hi Gysbert,
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 ))
