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

Thats an example question.

This is my question:

Question #2: Which three sites (Sites) receive the most number of Ocean (Mode) shipments and which shipping state (SH ST) has the most frequent shipments for each of the three sites?
A. Which three sites (Sites) received the most number of Ocean (Mode) shipments?
B. What is the total number of Ocean shipments for each of the sites in question 2A?
C. Which shipping state (Sh St) made the greatest number of Ocean shipments to each of the sites in question 2A?
D. Sort the pivot table by sites and shipping states in descending order by the number of Ocean shipments.
	(Hint: Count the number of I/O or PayDt)
		1st	2nd	3rd
A.	Site
B.	Number of Shipments
C.	Sh St

I have a data sheet filled with lots of numbers. The titles of the columns are down below. How would I figure the table out

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