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.
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 Field2A 100B 100B 200C 200C 300
If you create a table with the following dimension and measure:
Dimension: Field1Measure: 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 Field2Total 100A 100B 100C 200
When choosing Sum, your output will look like this because it sums up all of the values of the rows:
Field1 Field2Total 400A 100B 100C 200