Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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..
Ok, what do you want / expect then? Can you give an example?
hi
the problem is resolved.
thanks..
Hi,
I've the same kind a problem.
Could you please describe the way you solved yours?
Thanks in advance
Antonio
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.