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 538772.12 6833 3 B. Total Amount Paid C. Carrier 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 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 Question #3: Which three shipping states (Sh St) shipped the most total weight (Wgt) during May, June, and July, and which carrier (Carrier) was used to ship the most weight for each of the three shipping states? A. Which three shipping states (Sh St) shipped the most total weight (Wgt) during May, June, and July? B. What is the total weight (Wgt) shipped during May, June, and July by the shipping states in question 3A? C. Which carrier (Carrier) was used to ship the most weight for each of the shipping states from question 3A? D. Sort the pivot table by shipping states in descending order by the total weight for May, June, and July. 1st 2nd 3rd A. Sh St B. Total weight C. Carrier Question #4: On which three pay dates (Pay Dt) were the greatest amount spent (Pd Amt) on Air (Mode) shipments and which site (Site) paid the most for Air shipments on those dates? A. On which three paid dates (Pay Dt) were the greastest amount spent (Pd Amt) on Air (Mode) shipments? B. What is the total amount paid for Air shipments on each of the three dates from question 4A? C. Which site (Site) paid the most for Air shipments on each of the three dates from question 4A? D. Sort the pivot table by paid dates and sites 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 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

Retrieving data. Wait a few seconds and try to cut or copy again.

Retrieving data. Wait a few seconds and try to cut or copy again.