Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?

You have the following dataset.

Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?
A . {FIXED: [Region] SUM Sales}
B . {FIXED: SUM Sales}
C . {Fixed: [Region]: TOTAL Sales}
D . {FIXED: TOTAL (Sales)}

View Answer

Answer: D

Explanation:

To calculate the grand total of all the regions, you need to use a Level of Detail (LOD) expression that ignores any dimensions in the view and returns the total sum of sales. The FIXED keyword allows you to specify the level of detail for the calculation, and the TOTAL function returns the sum of all values in the expression. Therefore, the correct LOD expression is {FIXED: TOTAL (Sales)}.

Reference:

https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm

https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#TOTAL