ExamGecko
Question list
Search
Search

List of questions

Search

Question 42 - Desktop Certified Associate discussion

Report
Export

Which calculation will color the sales by state, while the city is on the Marks card, as shown in this view?

Larger image

A.
{SUM([Sales])}
Answers
A.
{SUM([Sales])}
B.
{ Exclude [City] : SUM([Sales])}
Answers
B.
{ Exclude [City] : SUM([Sales])}
C.
{ Exclude [State] : SUM([Sales])}
Answers
C.
{ Exclude [State] : SUM([Sales])}
D.
{ Exclude : SUM([Sales])}
Answers
D.
{ Exclude : SUM([Sales])}
Suggested answer: B

Explanation:

{ Exclude [City] : SUM([Sales])} => using this calculation we can exclude the City dimension from all the dimensions present in the view. So here SUM(sales) would be the aggregation of sales in the state level only, even though city field is available in the view.

asked 23/09/2024
giorgi durglishvili
42 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first