Create a pivot table from the Foodmart.cub file. Then for each product family and each product department,

Question:

Create a pivot table from the Foodmart.cub file. Then for each product family and each product department, find the percentage of line items (from the Fact Count measure) of Canada, Mexico, and the three regions of the USA. For example, you should find that 48.27% of all line items in the Alcoholic Beverages department were sold in the Northwest region of the USA.

Fantastic news! We've Found the answer you've been seeking!