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
Retrieving data ...