Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 wonkymeister
		
			wonkymeister
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
I have a pivot table, with YEAR across the top (3 years so 3 columns), with the user being able to select from a list of available dimensions down the side.
I need the % to calculate for each individual column (year), as opposed to a percentage of the total.
Any ideas?
 
					
				
		
 jmvilaplanap
		
			jmvilaplanap
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I think no, because there is in a pivot table, then automatically the results are "filtered" to fit each cell, is because you need to use "TOTAL"
It will be possible to use it in a text object using filters, but I think is not that are you looking for.
