Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
Can anyone here explain the difference between sum(sales) vs sum(total sales) with an example?
Many thanks,
Murali
Hi,
I explain with an example like:-
ColA, Value
A, 200
B, 300
C, 400
1. so If you take a chart with expression Sum(Value)
Dimension: ColA and
Expression: Value
it will shown
200 , 300 , 400
2. If you create a chart with expression Sum(Total value)
Dimension: ColA and
Expression: Value
it will shown 900 for all values for A,B,C
Thanks & Rgds
Hi,
I explain with an example like:-
ColA, Value
A, 200
B, 300
C, 400
1. so If you take a chart with expression Sum(Value)
Dimension: ColA and
Expression: Value
it will shown
200 , 300 , 400
2. If you create a chart with expression Sum(Total value)
Dimension: ColA and
Expression: Value
it will shown 900 for all values for A,B,C
Thanks & Rgds
Hi
The TOTAL keyword causes the dimensions to be ignored. You can also qualify the total to ignore specific dimensions. If you have a chart/table with dimensions Dim1 and Dim2 then
Sum(Total Sales) will ignore both dimensions (but will respect any selections you have made)
Sum(Total <Dim2> Sales) will show the total Sales by Dim1, ignoring Dim2
Hope that helps
Jonathan
Thanks for your help.
Regards,
Murali
Sorry, I think for: "Sum(Total <Dim2> Sales)" will show the total Sales by Dim2, while ignoring Dim1.
Sales will be returned for each combination of field values in the listed dimension fields.
Hi,
Inline table 1:
A, 50
B, 50
C, 200
sum(sales) will result in the total being sum(sales for A,B,C) which is 300
If you want to do A/(A+B+C), use total.
Hi,
I explain with an example like:-
ColA, Value
A, 200
B, 300
C, 400
1. so If you take a chart with expression Sum(Value)
Dimension: ColA and
Expression: Value
it will shown
200 , 300 , 400
2. If you create a chart with expression Sum(Total value)
Dimension: ColA and
Expression: Value
it will shown 900 for all values for A,B,C
Thanks & Rgds