Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi all
My requirement is create calculated dimension based on condition
here in dimension i need show the customers with minimum amount = 500 in my pie chart with thair amount
issue: getting syntax error
check application
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Your variable was empty... once I added 500 from variable overview, it seems to be working.
 aarkay29
		
			aarkay29
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Or you can try like this
sum({<Amount={">=$(=$(vMinimumAmount))"}>}Amount) as expression for Amount >=500
and [Customer Name] as dimension
