What is the significance of the TOTAL() function in Tableau versus SUM() with a FIXED LOD?

Tableau Hard

Tableau — Hard

What is the significance of the TOTAL() function in Tableau versus SUM() with a FIXED LOD?

Key points

  • TOTAL() considers the visible values in the current partition
  • FIXED LOD SUM operates at a specified dimension level
  • The two functions respond differently to view filters
  • Dimension levels impact FIXED LOD SUM calculations

Ready to go further?

Related questions