Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
sometimes when i use the aggr() function inside and expression (ie to get sum of rows in a pivot table)
i get confused where to put the set analysis expression
for example
let say i have this expression:
avg(aggr(sum(sales),DimA,DimB)))
i want to put a set analysis expression like {<DimC={1}>}
but where do i put it
in the internal sum() on the aggr() or on the external avg()
what is the result in each case?
what is the order of evaluation?
Mansyno
Hi Mansyno,
See my attached file with comments, let me know if this helps answer your question.
i think that, you have the put the set analysis int avg() and sum() function:
avg({<DimC={1}>} aggr( sum({<DimC={1}>} sales),DimA,DimB))