Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 qv_testing
		
			qv_testing
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Community,
How to set Alternate colors in Pivot table and
how many dimension possible in pivot table
Thanks....
 
					
				
		
 er_mohit
		
			er_mohit
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		dimension + expression = 15 maximum upto 15 field you can add but your linkage should be fine otherwise it gives you error object out of memory and allocated memory exceed
for alternate color write this code either in dimension or expresion side click on + icon you cee the background color write this code
If(Even(RowNo(TOTAL)), RGB(255,0,0),rgb(12,231,255))
 qv_testing
		
			qv_testing
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Mohit,
is it possible any column level..
 qv_testing
		
			qv_testing
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Mohit,
i have requirement, they are asking 50 dimensions in PIVOT table
is it possible or not?
Thanks..
 tresesco
		
			tresesco
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		There is no such documented limitation i believe. All you have to be careful of is, the performance, because the more the number of columns in pivot table more the performance (front end) degrades, i.e, your pivot may take long time to open.
