TDA-C01 Exam QuestionsBrowse all questions from this exam
Go to Exam

TDA-C01 Exam - Question 14

You have the following dataset.

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

Show Answer
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

9 comments
Sign in to comment
fatOption: B
Sep 11, 2023

Why is it not A?

VedjhaOption: B
Aug 4, 2023

B is correct answer

Steffi160Option: B
Aug 30, 2023

B is correct answer

Dk1984Option: B
Sep 20, 2023

B is correct answer

Eden666Option: D
Jul 25, 2023

Why is not D

CollectiveConsciousness
Aug 2, 2023

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"

maheshadithya12345678Option: B
Jul 30, 2023

BECAUSE TOTAL CANNOT BE USED WITH SALES TOTAL(SUM(SALES))

Vedjha
Aug 4, 2023

answer is correct

MonBoujOption: B
May 28, 2024

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

BenzloverOption: B
Jun 7, 2024

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.