Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 0li5a3a
		
			0li5a3a
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi all,
Could someone adivce me how to DON'T display the " -" into the Pivot Table and Bart Chart?
I want to mention that I still want to display the Months with no data in it but I don't want to see this " - " in the legend in the Bart Chart and in Type in the Pivot Table.
Please find the attached files where I have created a scenario.
Kind regards,
C
 0li5a3a
		
			0li5a3a
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi all,
I come with the solution, please use it in future if you need to exclude the nulls from legends.
Regards, C
 Chanty4u
		
			Chanty4u
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		in dimension
check supres null value .
in presentation tab also do the same
 
					
				
		
 dapostolopoylos
		
			dapostolopoylos
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 0li5a3a
		
			0li5a3a
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi ,
If you do this you would not be able to see Sep, Nov and Dec and I want to be able to see it.
Regards,
 0li5a3a
		
			0li5a3a
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		This is not right, I want to see Sep, Oct, Nov and Dec in my charts.
 0li5a3a
		
			0li5a3a
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Any guru expers?
 
					
				
		
 dapostolopoylos
		
			dapostolopoylos
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Have you tried to play with the "Show All Values" checkbox?
 0li5a3a
		
			0li5a3a
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Yes, but stii the same:)
 
					
				
		
 sergio0592
		
			sergio0592
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi, in pivot chart you can manage Missing value/Nul symbol and remove -

 0li5a3a
		
			0li5a3a
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		thnaks for that but still not done,
