The Access database file Foodmart.mdb mentioned earlier has the tables and relationships shown in Figure 17.1. Import the tables into an Excel Data Model. Then create a pivot table that shows, for each product family, the percentage of the total revenue from stores in each of the three countries (Canada, Mexico, and USA). For example, you should find that 26.20% of revenue for the Food family came from stores in Mexico.

Figure 17.1

Star Schema for Foodmart Database

Transcribed Image Text:

Relationships Products Productut Facts ProductCategory ProductDepartment ProductFanily DatetD CustomerlD Revenue UnitsSold StorelD Phonel PostalCode ear MorthOffear Manager