Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am trying to understand why I don't have the same result when I am using Auto in the total function for a measure and when I am using the Sum option.
Could you please explain to me how it is possible ?
I have already red the article "Expression total vs sum of rows" but it did not helped me to understand.
Thank you in advance.
Alexia
The Auto option uses your calculation for the total whereas the Sum option takes the values in the rows and adds them up.
For example, say you have the following data:
Field1 Field2
A 100
B 100
B 200
C 200
C 300
If you create a table with the following dimension and measure:
Dimension: Field1
Measure: min(Field2)
When choosing Auto, your output will look like this because it applied the Measure (in this case min) across all the values:
Field1 Field2
Total 100
A 100
B 100
C 200
When choosing Sum, your output will look like this because it sums up all of the values of the rows:
Field1 Field2
Total 400
A 100
B 100
C 200