In Tableau, what is a Superstore-style calculation for Profit Ratio, and why might SUM([Profit])/SUM([Sales]) give different results than AVG([Profit]/[Sales])?

Tableau Hard

Tableau — Hard

In Tableau, what is a Superstore-style calculation for Profit Ratio, and why might SUM([Profit])/SUM([Sales]) give different results than AVG([Profit]/[Sales])?

Ready to go further?

Related questions