Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi,
I have a Pivot table . I need to show the blank values count. I can able to get the count. But my problem is I can able to make the blank values label as 'Default' in both horizontal and vertical. I an able to get in vertical. I need in horizontal? Is it possible. Please see attached.
Thanks.
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		As usual please provide sample data file or sample apps.
 
					
				
		
Please see attached.
 
					
				
		
 sujeetsingh
		
			sujeetsingh
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		use nullcount()
 
					
				
		
I need the label as 'Default' in horizontal also? where can I use nullcount()
