Question: Proceed as in Problem 1, but now create a pivot table that has two fields from the Products table, Product Family and Product Department, in

Proceed as in Problem 1, but now create a pivot table that has two fields from the Products table, Product Family and Product Department, in the Rows area and two fields from the Stores table, Country and Region, in the Columns area. Use this to find the percentage of revenue from any product family or any product department that comes from any country or any region of any country. That is, a single pivot table should answer all such questions. For example, you should find that 17.48% of all revenue from the Seafood department comes from the Central region of Mexico?

Step by Step Solution

3.50 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Sum of Revenue Country Region Canada Canada Total Mexico Mexico Total USA USA Total Grand Total ProductFamily ProductDepartment Canada West Mexico Cen... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (3 attachments)

PDF file Icon

1209_60bca5b5aebad_564926.pdf

180 KBs PDF File

Excel file Icon

1209-M-S-D-A(8955).xlsx

300 KBs Excel File

Word file Icon

1209_60bca5b5aebad_564926.docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!