Question: Example question: 1. A separate pivot table worksheet must be provided for each question. Title the pivot sheet for the question it relates to in
Example question:
1. A separate pivot table worksheet must be provided for each question. Title the pivot sheet for the question it relates to in the same way as the pivot sheet for the Example Question is titled.
2. The pivot table needs to be sorted according to the question requirements. For example, the Example Question asked for the three shipping states with the highest total amount paid (Pd Amt),
therefore, the pivot table is sorted in descending order by total payment.
3. Answers to each question must be provided in the corresponding pivot sheet. Refer to "Example Question" worksheet for how to present answers.
| Example Question : Which three shipping states (SH ST) have the highest total amount paid (Pd Amt) for Air (Mode) and which carrier was paid the most for each of the three shipping states? | |||||
| A. Which three shipping states (Sh St) have the highest total paid amount (Pd Amt) for Air (Mode) shipments? | |||||
| B. What is the total amount paid for Air shipments from each of the shipping states in question 1A? | |||||
| C. Which carrier was paid the most for Air shipments from each of the three shipping states in question 1A? | |||||
| D. Sort the pivot table by shipping states and carriers in descending order by the total amount paid for Air shipments. | |||||
| 1st | 2nd | 3rd | |||
| A. | Sh St | CN | SE | AT | |
| B. | Total Amount Paid | 277,448.00 | 128,948.00 | 93,850.00 | |
| C. | Carrier | SCHENKER INTERN | SCHENKER INTERN | KUEHNE & NAGEL | |
My Question:
| Question #4: Which three sites (Sites) paid the most in fuel charges (Fuel Chg) on LTL (Mode) shipment and for each of the three site which carrier (Carrier) charged the most for fuel charges? | ||||||
| A. Which three sites (Sites) paid the most in fuel charges (Fuel Chg) on LTL (Mode) shipment? | ||||||
| B. What is the fuel charge on LTL shipments for the three sites from question 5A? | ||||||
| C. Which carrier (Carrier) charged the most for each of the three sites from question 5A? | ||||||
| D. Sort the pivot table by sites and carriers in descending order by fuel charge. | ||||||
| 1st | 2nd | 3rd | ||||
| A. | Site | |||||
| B. | Fuel Charge | |||||
| C. | Carrier | |||||
I have a data sheet full of like 20,000 different rows an all columns are labeled.
| Carrier | Scac | Mode | Fuel Chg | Miles | Pd Amt | Loc# | Site | Pcs | Wgt | Pay Dt | I/O | Sh City | Sh St | Sh Zip | D City | D St | D Zip |
How do I solve this with the data sheet numbers?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help