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 #1: Which three shipping states (SH ST) have the highest total amount paid (Pd Amt) for LTL (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 LTL (Mode) shipments?
B. What is the total amount paid for LTL shipments from each of the shipping states in question 1A?
C. Which carrier was paid the most for LTL 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 LTL shipments.
		1st	2nd	3rd
A.	Sh St
B.	Total Amount Paid
C.	Carrier

I have a data sheet that is filled with like 20,000 different numbers. The titles for the columns are below. Useing the titles can you help me figure out how to solve this?

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