Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi everyone,
I have a chart with two expressions. The first expression must have one dimension and the second expression must have a different dimension. In my case, it doesn't work using the conditional option on dimensions tab. Is it achievable using another method?
Any ideas are welcome.
Thank you.
 
					
				
		
 alexandros17
		
			alexandros17
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Use for example Sum(Total <field1, field2...> expr.)
 
					
				
		
.png) JonnyPoole
		
			JonnyPoole
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Can you post a screenshot of what you are trying to achieve ?
 
					
				
		
Sounds like you just need to enter the expressions differently.
i.e
expression 1 (current year) would be:
sum({$<Year={$(=Only(Year))}>}qty)
expression 2 (previous year) would be:
sum({$<Year={$(=Only(Year)-1)}>}qty)
But you would need to post what you are looking to acheive
