Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 sara12
		
			sara12
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		
 
					
				
		
 Or
		
			Or
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		In a pivot table, a subtotal or total will apply the same formula as the detailed measure, e.g. if your measure is sum(Sales), the total will also be sum(Sales). This cannot be modified directly, though you can use Dimensionality() to force a different formula for subtotals / totals if desired.
 sara12
		
			sara12
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Can you please give me an example of how to use this function Dimensionality() in my case.
thaks
 
					
				
		
 Or
		
			Or
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Unfortunately not - you've included no details about your existing dimensions, measures, or data structure, just a screen capture of some numbers. I'd suggest checking the documentation for examples:
