6 Replies Latest reply: Apr 19, 2012 5:10 AM by Ankit Jain RSS

    aggr function

      Hi friends

       

      i am using aggr function and set analysis to prepare an expression and its working fine but its working only on selection of dimension. I want that data should be shown without selection of dimension .

       

      my expression is : =aggr(Count( DISTINCT {<CODE-= {'000','001'}  >} [ID]),Circle)

       

      Here i have 'Circle' as Dimension. Expression value is displayed only when i select the Circle. I want the Expression values without Selecting Circle.

       

      Can anyone help me in this????

       

       

      Thanks

      Ankit