Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi I have a Pivot Table with 1 Dimension ( A value List with 2 Values "Tax" + "Amount") and several expresions related with the VAT TAX. Not every month these expressions have values, most of the time their value is 0. What I would like to know if it's possible to Hide ( or not tho show) a row (expression) when its value is 0.
Here's a picture
Thanks in advance!!
 
					
				
		
 whiteline
		
			whiteline
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi.
There is a checkbox 'supress zero-values' on presentation tab.
upd:
Ok, but it doesn't work for expressions
If you use QV11 you can show your expression conditionally (toggle check box Conditional on expressions tab and write a check expression).
 
					
				
		
 whiteline
		
			whiteline
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi.
There is a checkbox 'supress zero-values' on presentation tab.
upd:
Ok, but it doesn't work for expressions
If you use QV11 you can show your expression conditionally (toggle check box Conditional on expressions tab and write a check expression).
 
					
				
		
Ok!! Thanks
