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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started