ExamGecko
Question list
Search
Search

Question 11 - TDS-C01 discussion

Report
Export

Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through 2014, respectively?

A.
5,129 and 88,872
Answers
A.
5,129 and 88,872
B.
52,678 and 311,404
Answers
B.
52,678 and 311,404
C.
1,807 and 34,571
Answers
C.
1,807 and 34,571
D.
4,888 and 17,817
Answers
D.
4,888 and 17,817
Suggested answer: D

Explanation:

To reach the correct answer, follow these steps:

1) Drag Order Date (Discrete Year) to the Column shelf, and Region to the Row Shelf as shown:

2) Drag Profit to Text in the Marks Shelf as shown:

3) Click on Analysis as shown -> Totals -> SELECT ROW GRAND TOTALS

The following will be the final view:

You could also Filter by Region to only Focus on Canada, but that's your choice:

THEREFORE,

2012 = 4,888

2011 -> 2014 = 17,817

asked 23/09/2024
Martin Gucký
51 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first