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