2 Replies Latest reply: May 22, 2013 8:12 AM by Yves Ndjoli RSS

    set analysis and the AGGR() function question

    DANIEL CHOTZEN

      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