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?
Correct Answer: D
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
