Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 msantarone
		
			msantarone
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello, I need to obtain the % participation of the Premio measure in each of the columns per month (not the Total Premio but the Premio of the month).
In the measure "% Dv Premio/ Premio" I use the following formula: Sum (Premio) / Aggr (Sum (Premio), PeriodId) - but it only works well for Mendoza province. Why not go for all?
See attached.
 Kushal_Chawda
		
			Kushal_Chawda
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		@msantarone try below
Sum (Premio) / Sum (total <PeriodId>Premio)
 msantarone
		
			msantarone
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thanks, but it works the same as column "% Dv Premio / Total Premio"
 Kushal_Chawda
		
			Kushal_Chawda
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		@msantarone try to add first dimension as well
Sum (Premio) / Sum (total <Dim1,PeriodId>Premio)
