aggr function

[#1]

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

[swuehl]

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

[#3]

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

[swuehl]

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

[#5]

hi

the problem is resolved.

thanks..

[antrtiz001]

Hi,

I've the same kind a problem.

Could you please describe the way you solved yours?

Thanks in advance

Antonio

[#7]

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.