ExamGecko
Question list
Search
Search

List of questions

Search

Question 49 - Desktop Certified Associate discussion

Report
Export

Which LOD calculations can be used in Columns shelf to create this view?

Larger image

A.
{ FIXED [Category] : SUM([Profit])}
Answers
A.
{ FIXED [Category] : SUM([Profit])}
B.
{ FIXED [Region] : SUM([Profit])}
Answers
B.
{ FIXED [Region] : SUM([Profit])}
C.
{FIXED : SUM([Profit])}
Answers
C.
{FIXED : SUM([Profit])}
D.
{SUM([Profit])}
Answers
D.
{SUM([Profit])}
Suggested answer: C, D

Explanation:

{ FIXED [Category] : SUM([Profit])} - It calculates the profit of each category. In our view, all the profits values are the same, so it is not the right answer.

{ FIXED [Region] : SUM([Profit])} - It calculates the profit of each region.

{SUM([Profit])} is equivalent to {FIXED : SUM([Profit])}. It is the table level scope, which means this is the profit of the entire dataset.

asked 23/09/2024
Chien-Chung Chen
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first