What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through 2014, respectively?

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
B . 52,678 and 311,404
C . 1,807 and 34,571
D . 4,888 and 17,817

View Answer

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