Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a. Sort the table by Pickup City and then by Route Order. b. Make the table and Excel Table and filter to show the largest

a. Sort the table by Pickup City and then by Route Order. b. Make the table and "Excel Table" and filter to show the largest 5 shipment loads. Calculate the average shipment load of these 5 values. c. Create a Pivot Table (on this sheet) from the table: show the max shipment loads (values) from each pickup city (rows) to each dropoff store (columns). Show Grand Totals for columns only. d. Create Calculated Items for Pickup City: NORTH = Baltimore + Rockville, SOUTH = Alexandria + Springfield + Vienna. Filter pickup cities to show these two items only (NORTH and SOUTH). e. Create a Pivot Chart from this pivot table (stacked column). Switch the row/column orientation. Add a slicer for dropoff store and filter for Bullseye, DoorMart, and GreenFloor.

I didn't know how to upload the excel file other than taking a screenshot but i needed instructions on how to do the following tasks. Thanks. image text in transcribed

Practice 4 (Lecture 4) a Sort the table by Pickup City and then by Route Order b Make the table and "Excel Table" and filter to show the largest 5 shipment loads. Calculate the average shipment load of these 5 values. c Create a Pivot Table (on this sheet) from the table: show the max shipment loads (values) from each pickup city (rows) to each dropoff store (columns). Show Grand Totals for columns only. d Create Calculated Items for Pickup City: NORTH - Baltimore + Rockville, SOUTH -Alexandria+Springfield+ Vienna. Filter pickup cities to show these two items only (NORTH and SOUTH) e Create a Pivot Chart from this pivot table (stacked column). Switch the row/column orientation. Add a slicer for dropoff store and filter for Bullseye, DoorMart, and GreenFloor. Truck Driver ID Route Order Plcku ff Store Shlpment Load Baltimore K-Sho Rockville DoorMart ABC1234 ABC1234 ABC1234 DEF5678 DEF5678 DEF5678 DEF5678 GI119101 GHI9101 GHI9101 KL1121 KL1121 KL1121 IKL1121 MNO3141 MNO3141 MNO3141 POR5161 POR5161 PORS161 STU7181 STU7181 STU7181 VWx9202 VWx9202 VWx9202 YZA1222 YZA1222 YZA1222 103 86 89 ringfieldGreenFloor Alexandria K-Sho Rockville Bullseye Springfield Left-Aid Vienna Alexandria GreenFloor Rockville DoorMart 13 84 73 72 147 76 118 65 17 Alexand DoorMart Baltimore K Sho Springield Lett Aid Vienna Alexandria Lett-Aid Baltimore Bullseye Vienna Alexandria GreenFloor Rockville K-Sho GreenFloor 53 Daor Mart 105 13.5 143 175 93 105 104 61 75 70 78 27 28 29 ringfield DaMarl Baltimoe K-Sho Rockville Left-Aid Springfield DoorMart Alexandria GreenFloo Rockville Left-Aid Vienna Alexandria K-Shop Rockvillc Left-Aid Springfield Bullscyc 32 Bulls Average of Top 5 Loads

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation And Management

Authors: Carlos Coronel, Steven Morris

14th Edition

978-0357673034

More Books

Students also viewed these Databases questions

Question

Outline a plan for the introduction of JIT at Cheng Parts Company.

Answered: 1 week ago

Question

2.5 Describe a social audit.

Answered: 1 week ago