Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 AbhijitBansode
		
			AbhijitBansode
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi All,
I have a pivot table, which shows partial sums for the third dimension.
and it is pivoted as shown below:

Partial sums are enables for Business Unit dimension.
Don't understand why total column lable is appearing twice.
Also, lower lable is left aligned and upper lable is center align.
Alignment for the dimension is set to Left.
Any Idea what could be the reason behind this?
Thanks,
Abhijit
 tresesco
		
			tresesco
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Could you post your sample app that demostrates the issue?
 
					
				
		
Hi Abijhit,
Try with below.
Remove the Sub Total option for Year field and see. I think you have enabled Sub Total Option for Year as well as Business Unit.
Santhosh G
 
					
				
		
 neha_shirsath
		
			neha_shirsath
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Abhijit,
Can you post some sample Data,it'll be more helpful.
-Neha
