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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Nov 05, 2024

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