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

    set analysis and the AGGR() function question



      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:



      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?