Once again, thank you in advance for your support. I run Tableau reports that can include millions of rows. When I want find a total and go 'Analysis' and then 'Total' I get very different results between 'Automatic' and 'Sum'. Can someone explain to me what 'Automatic' is doing? Many thanks;
It's my understanding that automatic uses the aggregation of the field you are using in the view. For example, If you are using AVG([Sales]) then automatic will display the total as AVG but if you are using sum then automatic will us sum as well.
Hope this helps!