Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends , i trying to subtotal at each level , but it is not working , please help .
I am attaching the screenshot.
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