set analysis and the AGGR() function question

[wizardo]

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

[RedSky001]

Hi Mansyno,

See my attached file with comments, let me know if this helps answer your question.

[yvesqlik]

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