Question
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.
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 LoadsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started