The correct answer is A since the format of LOD is:
{ FIXED [Dimension] : SUM([Measure]) }
Option B is incorrect since it doesn’t have dimension after ‘fixed’
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.
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
It is not A because , then we will be getting region Wise Sales value instead of Sum(sales) irrespective of Region. Since the Question is to get the Sales for all regions together, Option B looks correct
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"
upvoted 3 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
tarshad
1 month, 1 week agoBenzlover
5 months, 2 weeks agoMonBouj
5 months, 3 weeks agoDk1984
1 year, 2 months agofat
1 year, 2 months agothahb
1 month agoSteffi160
1 year, 2 months agoVedjha
1 year, 3 months agoVedjha
1 year, 3 months agomaheshadithya12345678
1 year, 3 months agoEden666
1 year, 4 months agoCollectiveConsciousness
1 year, 3 months ago