Please saw the excel sheet first & solve this problem in excel sheet according to my question. Please give me the excel file in g-mail.(It's a request).

My g-mail address- exoticworld999

or in whats-app - +8801643416471

QUESTIONS: By using this sales table create a pivot table showing the order date, city, salesperson and revenue. Show the average of revenue. Create Chart for pivot table.

Order Details for December 2014 Ship Name Karen Toh Karen Toh Christina Lee 12/28/14 12/09/14 $61.39 Order ID Order Date Customer ID Customer Name Address City State ZIP/Postal Code Country/Region Salesperson 1368 12/27/14 27 Company AA 789 27th Street Las Vegas NV 99999 USA Mariya Sergienko 1369 12/27/14 27 Company AA 789 27th Street Las Vegas NV 99999 USA Mariya Serglenko 1370 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1371 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1372 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1373 12/12/14 12 Company L 123 12th Street Las Vegas NV 99999 USA Mariya Sergienko 1374 12/12/14 12 Company L 123 12th Street Las Vegas NY 99999 USA Mariya Sergienko 1375 12/08/14 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer 1376 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1377 12/29/14 29 Company CC 789 29th Street Denver CO 99999 USA Jan Kotas 1378 12/03/14 3 Company C 123 3rd Street Los Angelas CA 99999 USA Mariya Sergienko 1379 12/06/14 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper 13.80 12/28/14 28 Company 88 789 28th Street Memphis TN 99999 USA Anne Larsen 1381 12/08/14 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer 1382 12/10/14 10 Company) 123 10th Street Chicago IL 99999 USA Laura Giussani 1383 12/07/14 7 Company G 123 7th Street Boise ID 99999 USA Nancy Freehafer 1384 12/10/14 10 Company! 123 10th Street Chicago 99999 USA Laura Giussani 1385 12/10/14 10 Company) 123 10th Street Chicago IL 99999 USA Laura Giussani 12/10/14 10 Company 123 10th Street Chicago IL 99999 USA Laura Giussani 1387 12/11/14 11 Company K 123 11th Street Miami FL 99999 USA Anne Larsen 1388 12/11/14 11 Company 123 11th Street Miami FL 99999 USA Anne Larsen 1389 12/01/14 1 Company A 123 1st Street Seattle WA 99999 USA Nancy Freehafer 1390 12/01/14 1 Company A 123 1st Street Seattle WA 99999 USA Nancy Freehafer 1391 12/01/14 1 Company A 123 1st Street Seattle WA 99999 USA Nancy Freehafer 1392 12/28/14 28 Company BB 789 28th Street Memphis TN 99999 USA Anne Larsen 1393 28 Company BB 789 28th Street Memphis TN 99999 USA Anne Larsen 1394 12/09/14 9 Company 123 9th Street Salt Lake City UT 99999 USA Robert Zare 1395 9 Company 123 9th Street Salt Lake City UT 99999 USA Robert Zare 1396 12/06/14 6 Company 123 6th Street Milwaukee WI 99999 USA Michael Neipper 1397 12/08/14 8 Company 123 8th Street Portland 99999 USA Nancy Freehafer 1398 12/08/14 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer 1399 12/25/14 25 Company Y 789 25th Street Chicago IL 99999 USA Laura Giussani 1400 12/26/14 26 Company z 789 26th Street Miami FL 99999 USA Anne Larsen 1401 12/26/14 26 Company z 789 26th Street Miami FL 99999 USA Anne Larsen 1402 12/26/14 26 Company Z 789 26th Street Miami FL 99999 USA Anne Larsen 1403 12/29/14 29 Company CC 789 29th Street Denver 99999 USA Jan Kotas 1404 12/06/14 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper 1405 12/27/14 27 Company AA 789 27th Street Las Vegas NV 99999 USA Mariya Serglenko 1406 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1407 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1408 12/12/14 12 Company L 123 12th Street Las Vegas NV 99999 USA Mariya Serglenko 1409 12/08/14 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer 1410 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1411 12/29/14 29 Company CC 789 29th Street Denver CO 99999 USA Jan Kotas 1412 12/03/14 3 Company C d Street Los Angelas CA Mariya Sergienko 1413 12/03/14 3 Company C 123 3rd Street Los Angelas CA 99999 USA Mariya Serglenko 1414 12/06/14 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper 1415 12/28/14 28 Company BB 789 28th Street Memphis TN 99999 USA Anne Larsen 12/08/14 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer 1417 12/10/14 10 Company 123 10th Street Chicago IL 99999 USA Laura Giussani 1418 12/07/14 7 Company G 123 7th Street Boise ID 99999 USA Nancy Freehafer 1419 12/10/14 10 Company 123 10th Street Chicago IL 99999 USA Laura Giussani 1420 12/11/14 11 Company 123 11th Street Miami FL 99999 USA Anne Larsen 1421 12/01/14 1 Company A 123 1st Street Seattle WA 99999 USA Nancy Freehafer 1422 12/28/14 28 Company BB 789 28th Street Memphis TN 99999 USA Anne Larsen 1423 12/09/14 9 Company 123 9th Street Salt Lake City UT 99999 USA Robert Zare 1424 12/06/14 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper 1425 12/08/14 & Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer 1426 12/25/14 25 Company Y 789 25th Street Chicago IL 99999 USA Laura Giussani 12/26/14 26 Company z 789 26th Street Miami FL 99999 USA Anne Larsen 1428 12/29/14 29 Company CC 789 29th Street Denver CO 99999 USA Jan Kotas 1429 12/06/14 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper 1430 12/06/14 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper 1431 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1432 12/03/14 3 Company 123 3rd Street Los Angelas CA 99999 USA Mariya Sergienko Category Beverages Dried Fruit & Nuts Dried Fruit & Nuts Dried Fruit & Nuts Dried Fruit & Nuts Beverages Beverages Baked Goods & Mixes Baked Goods & Mixes Candy Soups Sauces Beverages Candy Beverages Beverages Jams, Preserves Condiments Baked Goods & Mixes Dried Fruit & Nuts Beverages Beverages Beverages Beverages Soups Canned Meat Pasta Dairy Products Beverages Sauces Baked Goods & Mixes Baked Goods & Mixes Oil Soups Canned Meat Beverages Candy Oil Jams, Preserves $3,280.00 Region Shipped Date Shipper Name West 12/29/14 Shipping Company B West 12/29/14 Shipping Company B East 12/06/14 Shipping Company A East 12/06/14 Shipping Company A East 12/06/14 Shipping Company A West 12/14/14 Shipping Company B West 12/14/14 Shipping Company B North 12/10/14 Shipping Company East 12/06/14 Shipping Company C West 12/31/14 Shipping Company B West 12/05/14 Shipping Company B North 12/08/14 Shipping Company B South 12/30/14 Shipping Company C North 12/10/14 Shipping Company C East 12/12/14 Shipping Company B North 12/09/14 Shipping Company B East 12/12/14 Shipping Company A East 12/12/14 Shipping Company A East 12/12/14 Shipping Company A South 12/13/14 Shipping Company C South 12/13/14 Shipping Company C North 12/03/14 Shipping Company B North 12/03/14 Shipping Company B North 12/03/14 Shipping Company B South 12/30/14 Shipping Company C South 12/30/14 Shipping Company C West 12/11/14 Shipping Company A West 12/11/14 Shipping Company A North 12/08/14 Shipping Company B North 12/10/14 Shipping Company B North 12/10/14 Shipping Company B East 12/27/14 Shipping Company A South 12/28/14 Shipping Company C South 12/28/14 Shipping Company C South 12/28/14 Shipping Company C West 12/31/14 mpany! North 12/08/14 Shipping Company C West 12/29/14 Shipping Company B East 12/06/14 Shipping Company A East 12/06/14 Shipping Company A West 12/14/14 Shipping Company B North 12/10/14 Shipping Company C East 12/06/14 Shipping Company C West 12/31/14 Shipping Company B West 12/05/14 Shipping Company B West 12/05/14 Shipping Company B North 12/08/14 Shipping Company B South 12/30/14 Shipping Company C North 12/10/14 Shipping Company C East 12/12/14 Shipping Company B North 12/09/14 Shipping Company A East 12/12/14 Shipping Company A South 12/13/14 Shipping Company C North 12/03/14 Shipping Company C South 12/30/14 Shipping Company C West 12/11/14 Shipping Company A North 12/08/14 Shipping Company B North 12/10/14 Shipping Company B East 12/27/14 Shipping Company A South 12/28/14 Shipping Company C West 12/31/14 Shipping Company B North 12/08/14 Shipping Company C North 12/08/14 Shipping Company C East 12/06/14 Shipping Company A West 12/05/14 Shipping Company A Christina Lee Christina Lee John Edwards John Edwards Elizabeth Andersen Christina Lee Soo Jung Lee Thomas Axerr Francisco Prez-Olaeta Amritansh Raghav Elizabeth Andersen Roland Wacker Ming-Yang Xie Roland Wacker Roland Wacker Roland Wacker Peter Krschne Peter Krschne Anna Bedecs Anna Bedecs Anna Bedecs Amritansh Raghav Amritansh Raghav Sven Mortensen Sven Mortensen Francisco Prez-Olaeta Elizabeth Andersen Elizabeth Andersen John Rodman Run Liu Run Liu Run Liu Soo Jung Lee Francisco Prez-Olaeta Karen Toh Christina Lee Christina Lee John Edwards Elizabeth Andersen Christina Lee Soo Jung Lee Thomas Axerr Thomas Axerr Francisco Prez-Olaeta Amritansh Raghav Elizabeth Andersen Roland Wacker Ming-Yang Xie Roland Wacker Peter Krschne Anna Bedecs Amritansh Raghav Sven Mortensen Francisco Prez-Olaeta Elizabeth Andersen John Rodman Run Liu Soo Jung Lee Francisco Prez-Olaeta Francisco Prez-Olaeta Christina Lee Thomas Axerr Ship Address Ship City Ship State Ship ZIP/Postal Code Ship Country/Region Payment Type Product Name 789 27th Street Las Vegas NV 99999 USA Check Beer 789 27th Street Las Vegas NV 99999 USA Check Dried Plums 123 4th Street New York NY 99999 USA Credit Card Dried Pears 123 4th Street New York NY 99999 USA Credit Card Dried Apples 123 4th Street New York 99999 USA Credit Card Dried Plums 123 12th Street Las Vegas 99999 USA Credit Card Chai 123 12th Street Las Vegas 99999 USA Credit Card Coffee 123 8th Street Portland OR 99999 USA Credit Card Chocolate Biscuits Mix 123 4th Street New York NY 99999 USA Check Chocolate Biscuits Mix 789 29th Street Denver 99999 USA Check Chocolate 123 3rd Street Los Angelas CA 99999 USA Cash Clam Chowder 123 6th Street Milwaukee WI 99999 USA Credit Card Curry Sauce 789 28th Street Memphis TN 99999 USA Check Coffee 123 8th Street Portland OR 99999 USA Check Chocolate 123 10th Street Chicago IL 99999 USA Credit Card Green Tea 123 7th Street Boise ID 99999 USA Check Coffee 123 10th Street Chicago 99999 USA Credit Card Boysenberry Spread 123 10th Street Chicago IL 99999 USA Cash Cajun Seasoning 123 10th Street Chicago 99999 USA Check Chocolate Biscuits Mix 123 11th Street Miami FL 99999 USA Credit Card Dried Plums 123 11th Street Miami FL 99999 USA Check Green Tea 123 1st Street Seattle WA 99999 USA Cash Chai 123 1st Street Seattle WA 99999 USA Cash Coffee 123 1st Street Seattle WA 99999 USA Cash Green Tea 789 28th Street Memphis TN 99999 USA Credit Card Clam Chowder 789 28th Street Memphis TN 99999 USA Credit Card Crab Meat 123 9th Street Salt Lake City UT 99999 USA Check Ravioli 123 9th Street Salt Lake City UT 99999 USA Check Mozzarella 123 6th Street Milwaukee 99999 USA Credit Card Beer 123 8th Street Portland OR 99999 USA Check Curry Sauce 123 8th Street Portland OR 99999 USA Check Chocolate Biscuits Mix 789 25th Street Chicago IL 99999 USA Cash Scones 789 26th Street Miami FL 99999 USA Credit Card Olive Oil 789 26th Street Miami FL 99999 USA Credit Card Clam Chowder 789 26th Street Miami FL 99999 USA Credit Card Crab Meat 789 29th Street Denver 99999 USA Check Beer 123 6th Street Milwaukee 99999 USA Check Chocolate 789 27th Street Las Vegas NY 99999 USA Check Olive Oil 123 4th Street New York 99999 USA Credit Card Marmalade 1234th Street New York NY 99999 USA Credit Card Long Grain Rice 123 12th Street Las Vegas NV 99999 USA Credit Card Boysenberry Spread 123 8th Street Portland OR 99999 USA Credit Card Mozzarella 123 4th Street New York NY 99999 USA Check Boysenberry Spread 789 29th Street Denver co 99999 USA Check Chocolate 123 3rd Street Los Angelas CA 99999 USA Cash Syrup 123 3rd Street Los Angelas 99999 USA Cash Curry Sauce 123 6th Street Milwaukee WI 99999 USA Credit Card Crab Meat 789 28th Street Memphis 99999 USA Check Ravioli 123 8th Street Portland OR 99999 USA Check Mozzarella 123 10th Street Chicago IL 99999 USA Credit Card Almonds 123 7th Street Boise ID 99999 USA Cash Boysenberry Spread 123 10th Street Chicago IL 99999 USA Check Dried Plums 123 11th Street Miami FL 99999 USA Check Curry Sauce 123 1st Street Seattle WA 99999 USA Cash Crab Meat 789 28th Street Memphis TN 99999 USA Credit Card Coffee 123 9th Street Salt Lake City UT 99999 USA Check Clam Chowder 123 6th Street Milwaukee WI 99999 USA Credit Card Chocolate 123 8th Street Portland OR 99999 USA Check Chocolate 789 25th Street Chicago IL 99999 USA Cash Cajun Seasoning 789 26th Street Miami FL 99999 USA Credit Card Boysenberry Spread 789 29th Street Denver 99999 USA Check Fruit Cocktail 123 6th Street Milwaukee WI 99999 USA Check Dried Pears 123 6th Street Milwaukee WI 99999 USA Check Dried Apples 123 4th Street New York 99999 USA Cash Gnocchi 123 3rd Street Los Angelas CA 99999 USA Cash Green Tea Unit Price Quantity $14.00 $3.50 60 $30.00 81 $53.00 $3.50 75 $18.00 $46.00 61 $9.20 $9.20 97 $12.75 $9.65 89 $40.00 25 $46.00 19 $12.75 36 $2.99 93 $46.00 64 $25.00 $22.00 72 $9.20 $3.50 67 $2.99 $18.00 $46.00 82 $2.99 17 $9.65 38 $18.40 $19.50 85 $34.80 $14.00 85 $40.00 82 $9.20 47 $10.00 $21.35 49 $9.65 72 $18.40 99 $14.00 $12.75 100 $49.00 112 $81.00 62 $7.00 $32.00 54 $34.80 29 $32.00 35 $17.00 42 $10.00 $40.00 29 $39.00 $21.00 21 $20.00 $10.00 81 $32.00 91 $3.50 96 $40.00 81 $18.40 88 $46.00 92 $9.65 34 $12.75 41 $12.75 $22.00 74 $25.00 $39.00 41 $30.00 12 $53.00 $38.00 33 $2.99 12 Revenue Shipping Fee $266.00 $25.80 $210.00 $20.16 $2,430.00 $255.15 $4,399.00 $461.90 $262.50 $26.25 $1,746.00 $183.33 $2,806.00 $291.82 $257.60 $24.47 $892.40 $93.70 $293.25 $29.33 $858.85 $81.59 $1,000.00 $96.00 $874.00 $89.15 $459.00 $45.44 $278.07 $26.42 $2,944.00 $279.68 $2,100.00 $220.50 $1,584.00 $150.48 $552.00 $56.86 $234.50 $22.75 $143.52 $13.63 $1,152.00 $118.66 $3,772.00 $392.29 $50.83 $5.13 $366.70 $36.67 $460.00 $45.54 $1,657.50 $165.75 $626.40 $1,190.00 $115.43 $318.16 $432.40 $41.51 $990.00 $99.00 $1,046.15 $106.71 $694.80 $72.95 $1,821.60 $191.27 $140.00 $13.86 $1,275.00 $122.40 $0.00 $27.00 $1,377.00 $117.94 $196.00 $13.72 $0.00 $8.00 $2,923.20 $300.85 $0.00 $9.00 $0.00 $23.00 $280.00 $90.25 $480.00 $239.12 $0.00 $31.00 $0.00 $20.00 $0.00 $34.00 $450.00 $62.83 $0.00 $33.00 $301.00 $21.32 $3,080.00 $378.00 $680.80 $148.14 $1,794.00 $365.15 $530.75 $68.58 $1,096.50 $43.78 $1,185.75 $1,166.00 $84.48 $1,550.00 $546.00 $193.01 $2,190.00 $200.85 $3,763.00 $225.62 $2,812.00 $175.03 $296.01 $17.04 Grains 123 3rd 99999 USA Jams, Preserves Dairy Products Jams, Preserves Candy Condiments Sauces Canned Meat Pasta Dairy Products Dried Fruit & Nuts Jams, Preserves Dried Fruit & Nuts Sauces Canned Meat Beverages Soups Candy Candy Condiments Jams, Preserves Fruit & Veg Dried Fruit & Nuts Dried Fruit & Nuts Pasta Beverages $82.RS %% nunu $164.15 Order Details for December 2014 Ship Name Karen Toh Karen Toh Christina Lee 12/28/14 12/09/14 $61.39 Order ID Order Date Customer ID Customer Name Address City State ZIP/Postal Code Country/Region Salesperson 1368 12/27/14 27 Company AA 789 27th Street Las Vegas NV 99999 USA Mariya Sergienko 1369 12/27/14 27 Company AA 789 27th Street Las Vegas NV 99999 USA Mariya Serglenko 1370 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1371 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1372 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1373 12/12/14 12 Company L 123 12th Street Las Vegas NV 99999 USA Mariya Sergienko 1374 12/12/14 12 Company L 123 12th Street Las Vegas NY 99999 USA Mariya Sergienko 1375 12/08/14 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer 1376 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1377 12/29/14 29 Company CC 789 29th Street Denver CO 99999 USA Jan Kotas 1378 12/03/14 3 Company C 123 3rd Street Los Angelas CA 99999 USA Mariya Sergienko 1379 12/06/14 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper 13.80 12/28/14 28 Company 88 789 28th Street Memphis TN 99999 USA Anne Larsen 1381 12/08/14 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer 1382 12/10/14 10 Company) 123 10th Street Chicago IL 99999 USA Laura Giussani 1383 12/07/14 7 Company G 123 7th Street Boise ID 99999 USA Nancy Freehafer 1384 12/10/14 10 Company! 123 10th Street Chicago 99999 USA Laura Giussani 1385 12/10/14 10 Company) 123 10th Street Chicago IL 99999 USA Laura Giussani 12/10/14 10 Company 123 10th Street Chicago IL 99999 USA Laura Giussani 1387 12/11/14 11 Company K 123 11th Street Miami FL 99999 USA Anne Larsen 1388 12/11/14 11 Company 123 11th Street Miami FL 99999 USA Anne Larsen 1389 12/01/14 1 Company A 123 1st Street Seattle WA 99999 USA Nancy Freehafer 1390 12/01/14 1 Company A 123 1st Street Seattle WA 99999 USA Nancy Freehafer 1391 12/01/14 1 Company A 123 1st Street Seattle WA 99999 USA Nancy Freehafer 1392 12/28/14 28 Company BB 789 28th Street Memphis TN 99999 USA Anne Larsen 1393 28 Company BB 789 28th Street Memphis TN 99999 USA Anne Larsen 1394 12/09/14 9 Company 123 9th Street Salt Lake City UT 99999 USA Robert Zare 1395 9 Company 123 9th Street Salt Lake City UT 99999 USA Robert Zare 1396 12/06/14 6 Company 123 6th Street Milwaukee WI 99999 USA Michael Neipper 1397 12/08/14 8 Company 123 8th Street Portland 99999 USA Nancy Freehafer 1398 12/08/14 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer 1399 12/25/14 25 Company Y 789 25th Street Chicago IL 99999 USA Laura Giussani 1400 12/26/14 26 Company z 789 26th Street Miami FL 99999 USA Anne Larsen 1401 12/26/14 26 Company z 789 26th Street Miami FL 99999 USA Anne Larsen 1402 12/26/14 26 Company Z 789 26th Street Miami FL 99999 USA Anne Larsen 1403 12/29/14 29 Company CC 789 29th Street Denver 99999 USA Jan Kotas 1404 12/06/14 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper 1405 12/27/14 27 Company AA 789 27th Street Las Vegas NV 99999 USA Mariya Serglenko 1406 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1407 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1408 12/12/14 12 Company L 123 12th Street Las Vegas NV 99999 USA Mariya Serglenko 1409 12/08/14 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer 1410 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1411 12/29/14 29 Company CC 789 29th Street Denver CO 99999 USA Jan Kotas 1412 12/03/14 3 Company C d Street Los Angelas CA Mariya Sergienko 1413 12/03/14 3 Company C 123 3rd Street Los Angelas CA 99999 USA Mariya Serglenko 1414 12/06/14 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper 1415 12/28/14 28 Company BB 789 28th Street Memphis TN 99999 USA Anne Larsen 12/08/14 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer 1417 12/10/14 10 Company 123 10th Street Chicago IL 99999 USA Laura Giussani 1418 12/07/14 7 Company G 123 7th Street Boise ID 99999 USA Nancy Freehafer 1419 12/10/14 10 Company 123 10th Street Chicago IL 99999 USA Laura Giussani 1420 12/11/14 11 Company 123 11th Street Miami FL 99999 USA Anne Larsen 1421 12/01/14 1 Company A 123 1st Street Seattle WA 99999 USA Nancy Freehafer 1422 12/28/14 28 Company BB 789 28th Street Memphis TN 99999 USA Anne Larsen 1423 12/09/14 9 Company 123 9th Street Salt Lake City UT 99999 USA Robert Zare 1424 12/06/14 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper 1425 12/08/14 & Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer 1426 12/25/14 25 Company Y 789 25th Street Chicago IL 99999 USA Laura Giussani 12/26/14 26 Company z 789 26th Street Miami FL 99999 USA Anne Larsen 1428 12/29/14 29 Company CC 789 29th Street Denver CO 99999 USA Jan Kotas 1429 12/06/14 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper 1430 12/06/14 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper 1431 12/04/14 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini 1432 12/03/14 3 Company 123 3rd Street Los Angelas CA 99999 USA Mariya Sergienko Category Beverages Dried Fruit & Nuts Dried Fruit & Nuts Dried Fruit & Nuts Dried Fruit & Nuts Beverages Beverages Baked Goods & Mixes Baked Goods & Mixes Candy Soups Sauces Beverages Candy Beverages Beverages Jams, Preserves Condiments Baked Goods & Mixes Dried Fruit & Nuts Beverages Beverages Beverages Beverages Soups Canned Meat Pasta Dairy Products Beverages Sauces Baked Goods & Mixes Baked Goods & Mixes Oil Soups Canned Meat Beverages Candy Oil Jams, Preserves $3,280.00 Region Shipped Date Shipper Name West 12/29/14 Shipping Company B West 12/29/14 Shipping Company B East 12/06/14 Shipping Company A East 12/06/14 Shipping Company A East 12/06/14 Shipping Company A West 12/14/14 Shipping Company B West 12/14/14 Shipping Company B North 12/10/14 Shipping Company East 12/06/14 Shipping Company C West 12/31/14 Shipping Company B West 12/05/14 Shipping Company B North 12/08/14 Shipping Company B South 12/30/14 Shipping Company C North 12/10/14 Shipping Company C East 12/12/14 Shipping Company B North 12/09/14 Shipping Company B East 12/12/14 Shipping Company A East 12/12/14 Shipping Company A East 12/12/14 Shipping Company A South 12/13/14 Shipping Company C South 12/13/14 Shipping Company C North 12/03/14 Shipping Company B North 12/03/14 Shipping Company B North 12/03/14 Shipping Company B South 12/30/14 Shipping Company C South 12/30/14 Shipping Company C West 12/11/14 Shipping Company A West 12/11/14 Shipping Company A North 12/08/14 Shipping Company B North 12/10/14 Shipping Company B North 12/10/14 Shipping Company B East 12/27/14 Shipping Company A South 12/28/14 Shipping Company C South 12/28/14 Shipping Company C South 12/28/14 Shipping Company C West 12/31/14 mpany! North 12/08/14 Shipping Company C West 12/29/14 Shipping Company B East 12/06/14 Shipping Company A East 12/06/14 Shipping Company A West 12/14/14 Shipping Company B North 12/10/14 Shipping Company C East 12/06/14 Shipping Company C West 12/31/14 Shipping Company B West 12/05/14 Shipping Company B West 12/05/14 Shipping Company B North 12/08/14 Shipping Company B South 12/30/14 Shipping Company C North 12/10/14 Shipping Company C East 12/12/14 Shipping Company B North 12/09/14 Shipping Company A East 12/12/14 Shipping Company A South 12/13/14 Shipping Company C North 12/03/14 Shipping Company C South 12/30/14 Shipping Company C West 12/11/14 Shipping Company A North 12/08/14 Shipping Company B North 12/10/14 Shipping Company B East 12/27/14 Shipping Company A South 12/28/14 Shipping Company C West 12/31/14 Shipping Company B North 12/08/14 Shipping Company C North 12/08/14 Shipping Company C East 12/06/14 Shipping Company A West 12/05/14 Shipping Company A Christina Lee Christina Lee John Edwards John Edwards Elizabeth Andersen Christina Lee Soo Jung Lee Thomas Axerr Francisco Prez-Olaeta Amritansh Raghav Elizabeth Andersen Roland Wacker Ming-Yang Xie Roland Wacker Roland Wacker Roland Wacker Peter Krschne Peter Krschne Anna Bedecs Anna Bedecs Anna Bedecs Amritansh Raghav Amritansh Raghav Sven Mortensen Sven Mortensen Francisco Prez-Olaeta Elizabeth Andersen Elizabeth Andersen John Rodman Run Liu Run Liu Run Liu Soo Jung Lee Francisco Prez-Olaeta Karen Toh Christina Lee Christina Lee John Edwards Elizabeth Andersen Christina Lee Soo Jung Lee Thomas Axerr Thomas Axerr Francisco Prez-Olaeta Amritansh Raghav Elizabeth Andersen Roland Wacker Ming-Yang Xie Roland Wacker Peter Krschne Anna Bedecs Amritansh Raghav Sven Mortensen Francisco Prez-Olaeta Elizabeth Andersen John Rodman Run Liu Soo Jung Lee Francisco Prez-Olaeta Francisco Prez-Olaeta Christina Lee Thomas Axerr Ship Address Ship City Ship State Ship ZIP/Postal Code Ship Country/Region Payment Type Product Name 789 27th Street Las Vegas NV 99999 USA Check Beer 789 27th Street Las Vegas NV 99999 USA Check Dried Plums 123 4th Street New York NY 99999 USA Credit Card Dried Pears 123 4th Street New York NY 99999 USA Credit Card Dried Apples 123 4th Street New York 99999 USA Credit Card Dried Plums 123 12th Street Las Vegas 99999 USA Credit Card Chai 123 12th Street Las Vegas 99999 USA Credit Card Coffee 123 8th Street Portland OR 99999 USA Credit Card Chocolate Biscuits Mix 123 4th Street New York NY 99999 USA Check Chocolate Biscuits Mix 789 29th Street Denver 99999 USA Check Chocolate 123 3rd Street Los Angelas CA 99999 USA Cash Clam Chowder 123 6th Street Milwaukee WI 99999 USA Credit Card Curry Sauce 789 28th Street Memphis TN 99999 USA Check Coffee 123 8th Street Portland OR 99999 USA Check Chocolate 123 10th Street Chicago IL 99999 USA Credit Card Green Tea 123 7th Street Boise ID 99999 USA Check Coffee 123 10th Street Chicago 99999 USA Credit Card Boysenberry Spread 123 10th Street Chicago IL 99999 USA Cash Cajun Seasoning 123 10th Street Chicago 99999 USA Check Chocolate Biscuits Mix 123 11th Street Miami FL 99999 USA Credit Card Dried Plums 123 11th Street Miami FL 99999 USA Check Green Tea 123 1st Street Seattle WA 99999 USA Cash Chai 123 1st Street Seattle WA 99999 USA Cash Coffee 123 1st Street Seattle WA 99999 USA Cash Green Tea 789 28th Street Memphis TN 99999 USA Credit Card Clam Chowder 789 28th Street Memphis TN 99999 USA Credit Card Crab Meat 123 9th Street Salt Lake City UT 99999 USA Check Ravioli 123 9th Street Salt Lake City UT 99999 USA Check Mozzarella 123 6th Street Milwaukee 99999 USA Credit Card Beer 123 8th Street Portland OR 99999 USA Check Curry Sauce 123 8th Street Portland OR 99999 USA Check Chocolate Biscuits Mix 789 25th Street Chicago IL 99999 USA Cash Scones 789 26th Street Miami FL 99999 USA Credit Card Olive Oil 789 26th Street Miami FL 99999 USA Credit Card Clam Chowder 789 26th Street Miami FL 99999 USA Credit Card Crab Meat 789 29th Street Denver 99999 USA Check Beer 123 6th Street Milwaukee 99999 USA Check Chocolate 789 27th Street Las Vegas NY 99999 USA Check Olive Oil 123 4th Street New York 99999 USA Credit Card Marmalade 1234th Street New York NY 99999 USA Credit Card Long Grain Rice 123 12th Street Las Vegas NV 99999 USA Credit Card Boysenberry Spread 123 8th Street Portland OR 99999 USA Credit Card Mozzarella 123 4th Street New York NY 99999 USA Check Boysenberry Spread 789 29th Street Denver co 99999 USA Check Chocolate 123 3rd Street Los Angelas CA 99999 USA Cash Syrup 123 3rd Street Los Angelas 99999 USA Cash Curry Sauce 123 6th Street Milwaukee WI 99999 USA Credit Card Crab Meat 789 28th Street Memphis 99999 USA Check Ravioli 123 8th Street Portland OR 99999 USA Check Mozzarella 123 10th Street Chicago IL 99999 USA Credit Card Almonds 123 7th Street Boise ID 99999 USA Cash Boysenberry Spread 123 10th Street Chicago IL 99999 USA Check Dried Plums 123 11th Street Miami FL 99999 USA Check Curry Sauce 123 1st Street Seattle WA 99999 USA Cash Crab Meat 789 28th Street Memphis TN 99999 USA Credit Card Coffee 123 9th Street Salt Lake City UT 99999 USA Check Clam Chowder 123 6th Street Milwaukee WI 99999 USA Credit Card Chocolate 123 8th Street Portland OR 99999 USA Check Chocolate 789 25th Street Chicago IL 99999 USA Cash Cajun Seasoning 789 26th Street Miami FL 99999 USA Credit Card Boysenberry Spread 789 29th Street Denver 99999 USA Check Fruit Cocktail 123 6th Street Milwaukee WI 99999 USA Check Dried Pears 123 6th Street Milwaukee WI 99999 USA Check Dried Apples 123 4th Street New York 99999 USA Cash Gnocchi 123 3rd Street Los Angelas CA 99999 USA Cash Green Tea Unit Price Quantity $14.00 $3.50 60 $30.00 81 $53.00 $3.50 75 $18.00 $46.00 61 $9.20 $9.20 97 $12.75 $9.65 89 $40.00 25 $46.00 19 $12.75 36 $2.99 93 $46.00 64 $25.00 $22.00 72 $9.20 $3.50 67 $2.99 $18.00 $46.00 82 $2.99 17 $9.65 38 $18.40 $19.50 85 $34.80 $14.00 85 $40.00 82 $9.20 47 $10.00 $21.35 49 $9.65 72 $18.40 99 $14.00 $12.75 100 $49.00 112 $81.00 62 $7.00 $32.00 54 $34.80 29 $32.00 35 $17.00 42 $10.00 $40.00 29 $39.00 $21.00 21 $20.00 $10.00 81 $32.00 91 $3.50 96 $40.00 81 $18.40 88 $46.00 92 $9.65 34 $12.75 41 $12.75 $22.00 74 $25.00 $39.00 41 $30.00 12 $53.00 $38.00 33 $2.99 12 Revenue Shipping Fee $266.00 $25.80 $210.00 $20.16 $2,430.00 $255.15 $4,399.00 $461.90 $262.50 $26.25 $1,746.00 $183.33 $2,806.00 $291.82 $257.60 $24.47 $892.40 $93.70 $293.25 $29.33 $858.85 $81.59 $1,000.00 $96.00 $874.00 $89.15 $459.00 $45.44 $278.07 $26.42 $2,944.00 $279.68 $2,100.00 $220.50 $1,584.00 $150.48 $552.00 $56.86 $234.50 $22.75 $143.52 $13.63 $1,152.00 $118.66 $3,772.00 $392.29 $50.83 $5.13 $366.70 $36.67 $460.00 $45.54 $1,657.50 $165.75 $626.40 $1,190.00 $115.43 $318.16 $432.40 $41.51 $990.00 $99.00 $1,046.15 $106.71 $694.80 $72.95 $1,821.60 $191.27 $140.00 $13.86 $1,275.00 $122.40 $0.00 $27.00 $1,377.00 $117.94 $196.00 $13.72 $0.00 $8.00 $2,923.20 $300.85 $0.00 $9.00 $0.00 $23.00 $280.00 $90.25 $480.00 $239.12 $0.00 $31.00 $0.00 $20.00 $0.00 $34.00 $450.00 $62.83 $0.00 $33.00 $301.00 $21.32 $3,080.00 $378.00 $680.80 $148.14 $1,794.00 $365.15 $530.75 $68.58 $1,096.50 $43.78 $1,185.75 $1,166.00 $84.48 $1,550.00 $546.00 $193.01 $2,190.00 $200.85 $3,763.00 $225.62 $2,812.00 $175.03 $296.01 $17.04 Grains 123 3rd 99999 USA Jams, Preserves Dairy Products Jams, Preserves Candy Condiments Sauces Canned Meat Pasta Dairy Products Dried Fruit & Nuts Jams, Preserves Dried Fruit & Nuts Sauces Canned Meat Beverages Soups Candy Candy Condiments Jams, Preserves Fruit & Veg Dried Fruit & Nuts Dried Fruit & Nuts Pasta Beverages $82.RS %% nunu $164.15