Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
COUNTRY | <CYCLICGROUP> | PROJECTS | CUSTOMER | orderamount | YYMM | YYMM2 | YYMM 201303 | ||
---|---|---|---|---|---|---|---|---|---|
SUM(Orderamount) | SUM(Margin per month) | SUM(Margin per month) | SUM(Margin per month) | ||||||
This should be a distinct value | |||||||||
use aggr function on the basis of that you got orderamount
like
aggr(sum(distinct Orderamount),basedfieldname)
Please post the sample application
Hereby you receive the sample application as per your request.
But how will that work with Cyclic groups?
Also, I have to name all the dimensions right?
I've also upload an example file in another post just down...