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

# 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

• ###### aggr function

For more than one possible Circle, you will get multiple values returned.

You need to aggregate these values to get one unambiguous value returned, I would use a sum:

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

• ###### aggr function

using sum will give me sum of count(ID) for all the Circles without selecting any Circle.

I dont want the sum of Count values..

• ###### aggr function

Ok, what do you want / expect then? Can you give an example?

• ###### aggr function

hi

the problem is resolved.

thanks..

• ###### aggr function

Hi,

I've the same kind a problem.

Could you please describe the way you solved yours?

Antonio

• ###### aggr function

hi Antonio

i used if condition with Total fnc.

eg:

if(CODE<>'000' or '001',Count(TOTAL<Circle>ID))

add all the dimensions in the <> for which u want the count.