Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		

In the above table, the value "ADAPTER" in ITEM NAME field is a common value for both "VO" and "PTO" of DIV field.
I want to count how many such values in ITEM NAME has the same characteristic.
Please assist.
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I used this expression
Count(DISTINCT {<[ITEM NAME] = {"=Count(DISTINCT DIV) > 1"}>} [ITEM NAME])
and got this
What is wrong?
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		May be this
Count(DISTINCT {<[ITEM NAME] = {"=Count(DISTINCT DIV) > 1"}>} [ITEM NAME])
 
					
				
		
shall I use this same as it is ?
or I have to enter the values like "PTO" and "VO" anywhere ?
.png) 
					
				
		
 arvind1494
		
			arvind1494
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Count(DISTINCT {<[ITEM NAME = {'=Count(DISTINCT DIV) > 1'}]>} [ITEM NAME])
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Just try it as is
 
					
				
		
it is giving distinct count value for each ITEM NAME.
I need count for each ITEM NAME value having "VO" and "PTO" in DIV field.
Eg; For the above table, the count value for "adapter" should be one and the same for "actuator" as well.
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I am not sure I follow... is this what you want?
Dimension Value
ADAPTER 1
ACTUATOR 1
 
					
				
		
yes, correct!
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I used this expression
Count(DISTINCT {<[ITEM NAME] = {"=Count(DISTINCT DIV) > 1"}>} [ITEM NAME])
and got this
What is wrong?
 
					
				
		
Thanks Sunny and Arvind..  
 
