How does tableau calculate grand totals using automatic for percentage and median calculation aplied on measure?
When select "Automatic" while using grand total, it uses the formula underlying the calculation.
Profit Ratio = sum([Profit])/sum([Sales])
You can see in the image attached, grand total of "profit ratio" is
286397 / 2297201
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...