Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 agni_gold
		
			agni_gold
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Friends , i trying to subtotal at each level , but it is not working , please help .
I am attaching the screenshot.
 
					
				
		
 ToniKautto
		
			ToniKautto
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I am quite confident with that the results you see are accurate, based on your current expression. The result will depend on your dimension, expression, current selection and data model. It is impossible to explain why you get the result you get, or to suggest how you can get the expected result, based on a screenshot.
If the Sum() aggregation is fairly simple this issue can be commonly resolved by applying Aggr() in the below pattern.
Sum( Aggr( Sum(Expression), Dim1, Dim2, ... ,DimN )
Please attach a sample QVW so that dimension, expression, current selection and data model can be considered in more detail.
 
					
				
		
I expect this result if the expression is without explicit aggregation for example:
1
If it is
sum(1)
the totals will be rather different
