You have the following dataset.
Which Level of Detail (LOD) expression should you use to calculate the grand total of all the regions?
Exam TDA-C01 All QuestionsBrowse all questions from this exam
Question 14
Correct Answer: B
To calculate the grand total of all the regions, you should use the expression { FIXED : SUM(Sales) }. This Level of Detail (LOD) expression will sum the sales across all regions without being affected by any dimensions in the view, providing a grand total.
Discussion
fatOption: B
Why is it not A?
Dk1984Option: B
B is correct answer
Steffi160Option: B
B is correct answer
VedjhaOption: B
B is correct answer
BenzloverOption: B
To calculate the grand total of all the regions, you should use the following Level of Detail (LOD) expression: **B. { FIXED : SUM(Sales) }** This expression calculates the sum of sales across all regions, regardless of any dimensions in the view.
MonBoujOption: B
B. { FIXED : SUM(Sales) } Leaving it blank means that it shouldn't be grouped by or fixed on a particular dimension. The calculation will simply compute total sales for the entire database. This is the least granular calculation for total sales
Vedjha
answer is correct
maheshadithya12345678Option: B
BECAUSE TOTAL CANNOT BE USED WITH SALES TOTAL(SUM(SALES))
Eden666Option: D
Why is not D
CollectiveConsciousness
You can not use table calculations in fixed calculations. If you tried to enter that calculation in Tableau it would tell you "LODs can not be used with table calcs or attribute functions"