Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 agni_gold
		
			agni_gold
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		![2016-05-06 20_06_42-QlikView x64 - [C__Users_agnivesh_kumar_Desktop_New QlikView Document (3).qvw].jpg](/legacyfs/online/123761_2016-05-06 20_06_42-QlikView x64 - [C__Users_agnivesh_kumar_Desktop_New QlikView Document (3).qvw].jpg) Hi All ,
Hi All ,
I have one situation,
I am using pivot table , and it has 3 dimensions and one expression.
But i want to hide those rows which are null at the top level it is working fine like if i found null values in 2nd dimension this will work fine but if i got null value in 3rd dimension it is chaging my second level dimension total.
Can ypu please help me out here.
Thanks
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		What is the expected output here?
 
					
				
		
 agni_gold
		
			agni_gold
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		If i am suppressing null in 3rd column it will also suppress their respective number .
But i want here if i group at second level sum should 220 but if i un group 2nd level it should not show 130 value.
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Can you check now
=If(Dimensionality() = 2, Sum(four), Sum({<five = {'*'}>}four))
 
					
				
		
 agni_gold
		
			agni_gold
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		thanks but at the first level sum should be 300 for B
 trdandamudi
		
			trdandamudi
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Sunny,
Just for my knowledge purpose, What does the '*' represent ?
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I thought you would be able to play around with it to make it work according to your requirement.
Check this out 
=If(Dimensionality() = 3, Sum({<five = {'*'}>}four), Sum(four))
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		It means include all those five where they are not null 
 trdandamudi
		
			trdandamudi
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thank you.
 
					
				
		
 ankit777
		
			ankit777
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Agnivesh
Try something like this-file attached.
