7. Go to the Employees worksheet. Winoma wants to compare the data on this worksheet with delivery data, stored on the D
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
7. Go to the Employees worksheet. Winoma wants to compare the data on this worksheet with delivery data, stored on the D
7. Go to the Employees worksheet. Winoma wants to compare thedata on this worksheet with delivery data, stored on the Deliveriesworksheet. She wants to analyze the delivery charges by manager.Add the data in the range A3:D27 to the data model, specifying thetable you are creating has headers. Go to the Deliveries worksheet,and then add the data in the range A3:D27 to the data model,specifying the table you are creating has headers. In Power Pivot,rename Table1 using Employees as the new table name. Rename Table2using Deliveries as the new table name. Create a PivotTable on anew worksheet named Deliveries by Manager based on the Employeesand Deliveries tables.