A separate pivot table worksheet has to be provided for each question. Title the pivot sheet for the question it relates to as the pivot sheet for the Example Question is titled.
The pivot table needs to sorted depending upon the question. For example, the Example Question asked for the three shipping states with the highest total LTL miles to site QC,
therefore, the pivot table is sorted in descending order by total miles.
Example Question: Which three shipping states (Sh St) have the highest total LTL (Mode) miles (Miles) to the QC site (Site)
Sort pivot table by shipping states in descending order by the total miles.
		1st	2nd	3rd
	Sh St	MO	NC	NY
	Total Miles	38425	4100	3462

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 in descending order by the total amount paid for LTL shipments.

1st

2nd

3rd

A.

Sh St

B.

Total Amount Paid

C.

Carrier

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 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

Question #3: Which three shipping states (Sh St) shipped the most total number of pieces (Pcs) during the last three months (Oct, Nov, Dec) and which mode (Mode) was used to ship the most number of pieces for each of the three shipping states?

A. Which three shipping states (Sh St) shipped the most total number of pieces (Pcs) during the last three months (month)?

B. What is the total number of pieces (Pcs) shipped during the last three months by the shipping states in question 3A?

C. Which mode (Mode) was used to ship the most number of pieces for each of the shipping states from question 3A?

D. Sort the pivot table by shipping states in descending order by the number of pieces for the last three months.

1st

2nd

3rd

A.

Sh St

B.

Total Number of Pieces

C.

Mode

Question #4: On which three pay dates (Pay Dt) were the greatest amount spent (Pd Amt) on Ocean (Mode) shipments and which site (Site) paid the most for Ocean shipments on those dates?

A. On which three paid dates (Pay Dt) were the greastest amount spent (Pd Amt) on Ocean (Mode) shipments?

B. What is the total amount paid for Ocean shipments on each of the three dates from question 4A?

C. Which site (Site) paid the most for Ocean shipments on each of the three dates from question 4A?

D. Sort the pivot table by paid dates in descending order by the total amount paid.

1st

2nd

3rd

A.

Paid Date

B.

Total Amount Paid

C.

Site

Question #5: Which three sites (Sites) paid on average the most in fuel charges (Fuel Chg) per LTL (Mode) shipment and for each of the three site which carrier (Carrier) charge on average the most in fuel charges per shipment?

A. Which three sites (Sites) paid on average the most in fuel charges (Fuel Chg) per LTL (Mode) shipment?

B. What is the average fuel charge per LTL shipments for the three sites from question 5A?

C. Which carrier (Carrier) charged the most on average to each of the three sites from question 5A?

D. Sort the pivot table by sites in descending order by average fuel charge per shipment.

1st

2nd

3rd

A.

Site

B.

Average Fuel Charge

C.

Carrier