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