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?
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
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit