Question

In order to relate the data in the Products and Purchases tables to make a proper comparison, use the Power Pivot window to create a relationship between the Purchases and Products tables based on the ItemId field

Answer 1

To create a relationship between the Purchases and Products tables in the Power Pivot window, use the ItemId field as the basis for the relationship.

Step-by-step explanation:

To create a relationship between the Purchases and Products tables in the Power Pivot window, you can use the ItemId field as the basis for the relationship. Here are the steps:

1. Open the Power Pivot window in your spreadsheet program.
2. In the Power Pivot window, click on the 'Diagram View' tab.
3. Drag and drop the ItemId field from the Products table to the ItemId field in the Purchases table.
4. Ensure that the relationship is created as a one-to-many relationship, where one item can be associated with multiple purchases.
5. Save the changes and exit the Power Pivot window.