Spreadsheet: 386059d1427567453-working-with-advanced-filters-new-worksheet-2
Sheet: Shipping Data

ProductID | Date | Qty | City | State | ShipCost | Rush | Weight | Size_Cat | Unit_Cost
 |  |  |  | CA
 | Qty
Average
Sum
ProductID | Date | Qty | City | State | ShipCost | Rush | Weight | Size_Cat | Unit_Cost
B6655 | 2015-06-15 00:00:00 | 500 | Chicago | IL | 351
B7490 | 2015-01-31 00:00:00 | 150 | Cleveland | OH | 243.36
B7109 | 2015-02-27 00:00:00 | 75 | Cleveland | OH | 94.77
B9061 | 2015-04-05 00:00:00 | 150 | Dallas | TX | 48
B6655 | 2015-02-09 00:00:00 | 400 | New York | NY | 476.28 | Y
B7977 | 2015-05-03 00:00:00 | 325 | Dallas | TX | 57.33 | Y
B7109 | 2015-06-29 00:00:00 | 125 | Nashville | KY | 112.5
B5543 | 2015-06-05 00:00:00 | 400 | Houston | TX | 168
B6655 | 2015-06-17 00:00:00 | 225 | New York | NY | 291.6
B7977 | 2015-07-14 00:00:00 | 250 | New York | NY | 189
B2483 | 2015-03-23 00:00:00 | 150 | Kansas City | KS | 64.8
B7109 | 2015-05-08 00:00:00 | 225 | Nashville | KY | 354.38 | Y
B6655 | 2015-02-05 00:00:00 | 450 | New York | NY | 567
B5543 | 2015-04-08 00:00:00 | 350 | Anaheim | CA | 445.9
B3552 | 2015-06-28 00:00:00 | 400 | Columbus | OH | 235.2
B3726 | 2015-06-13 00:00:00 | 500 | Kansas City | KS | 189
B2483 | 2015-05-11 00:00:00 | 200 | New York | NY | 432
B8353 | 2015-03-29 00:00:00 | 275 | Kansas City | KS | 86.63
B9269 | 2015-03-03 00:00:00 | 450 | Anaheim | CA | 463.05 | Y
B9061 | 2015-03-11 00:00:00 | 150 | Miami | FL | 105
B9061 | 2015-05-31 00:00:00 | 500 | New York | NY | 810
B7490 | 2015-06-10 00:00:00 | 100 | Columbus | OH | 67.2
B7977 | 2015-06-03 00:00:00 | 325 | Nashville | KY | 170.63
B7109 | 2015-01-12 00:00:00 | 250 | Anaheim | CA | 231.53 | Y
B3552 | 2015-04-26 00:00:00 | 75 | Columbus | OH | 49.61 | Y
B4621 | 2015-06-27 00:00:00 | 275 | New York | NY | 346.5
B5543 | 2015-07-10 00:00:00 | 250 | Columbus | OH | 128.63 | Y
B9269 | 2015-07-16 00:00:00 | 150 | Nashville | KY | 75
B8549 | 2015-05-23 00:00:00 | 350 | Cleveland | OH | 229.32
B8076 | 2015-04-21 00:00:00 | 125 | New York | NY | 162
B9269 | 2015-07-14 00:00:00 | 425 | New York | NY | 506.05 | Y
B5479 | 2015-07-15 00:00:00 | 75 | Nashville | KY | 118.13
B9061 | 2015-04-10 00:00:00 | 250 | Tampa | FL | 252
B3552 | 2015-07-13 00:00:00 | 450 | Danville | IL | 436.59 | Y
B3726 | 2015-04-03 00:00:00 | 475 | New York | NY | 778.05
B4463 | 2015-03-28 00:00:00 | 450 | San Antonio | TX | 352.8 | Y
B6655 | 2015-02-01 00:00:00 | 275 | Chicago | IL | 125.13
B9061 | 2015-01-23 00:00:00 | 75 | Cleveland | OH | 63.18
B3552 | 2015-02-24 00:00:00 | 500 | Cleveland | OH | 421.2
B3552 | 2015-04-26 00:00:00 | 125 | Chicago | IL | 169
B9269 | 2015-03-01 00:00:00 | 350 | Houston | TX | 110.25
B7109 | 2015-04-19 00:00:00 | 200 | Columbus | OH | 224
B5479 | 2015-05-30 00:00:00 | 275 | Oklahoma City | OK | 46.2
B7109 | 2015-05-09 00:00:00 | 200 | New York | NY | 345.6
B8353 | 2015-03-07 00:00:00 | 125 | Tampa | FL | 96
B7109 | 2015-03-14 00:00:00 | 100 | San Antonio | TX | 89.6 | Y
B7109 | 2015-01-09 00:00:00 | 100 | Cleveland | OH | 62.4
B8076 | 2015-06-24 00:00:00 | 275 | Miami | FL | 303.19
B8549 | 2015-03-11 00:00:00 | 175 | Oklahoma City | OK | 26.46 | Y
B7977 | 2015-04-20 00:00:00 | 300 | Columbus | OH | 147
B9061 | 2015-06-05 00:00:00 | 400 | Oklahoma City | OK | 50.4
B6655 | 2015-01-07 00:00:00 | 350 | Columbus | OH | 360.15 | Y
B3614 | 2015-03-20 00:00:00 | 400 | Cleveland | OH | 567.84
B6655 | 2015-01-09 00:00:00 | 75 | Anaheim | CA | 49.61 | Y
B4463 | 2015-07-14 00:00:00 | 225 | Danville | IL | 129.6
B5543 | 2015-05-22 00:00:00 | 500 | Kansas City | KS | 351
B7490 | 2015-03-15 00:00:00 | 400 | Anaheim | CA | 235.2
B4463 | 2015-02-24 00:00:00 | 200 | Columbus | OH | 211.68 | Y
B5479 | 2015-03-19 00:00:00 | 475 | Cleveland | OH | 726.18
B5479 | 2015-03-13 00:00:00 | 175 | Houston | TX | 77
B7490 | 2015-04-05 00:00:00 | 200 | San Antonio | TX | 128
B2533 | 2015-07-12 00:00:00 | 100 | Dallas | TX | 41.6
B3726 | 2015-04-16 00:00:00 | 225 | Nashville | KY | 202.5
B8353 | 2015-06-11 00:00:00 | 425 | Kansas City | KS | 321.3
B3726 | 2015-02-27 00:00:00 | 200 | San Francisco | CA | 134.4 | Y
B7109 | 2015-02-03 00:00:00 | 300 | Dallas | TX | 109.2
B7977 | 2015-02-11 00:00:00 | 200 | Oklahoma City | OK | 16
B3614 | 2015-01-16 00:00:00 | 75 | San Antonio | TX | 64.8
B5543 | 2015-03-12 00:00:00 | 250 | Kansas City | KS | 141.75
B8353 | 2015-01-25 00:00:00 | 375 | San Francisco | CA | 378
B6655 | 2015-05-01 00:00:00 | 475 | Kansas City | KS | 269.33
B8549 | 2015-01-17 00:00:00 | 125 | Houston | TX | 45
B3614 | 2015-06-14 00:00:00 | 375 | San Francisco | CA | 420
B5479 | 2015-04-02 00:00:00 | 425 | Oklahoma City | OK | 56.23 | Y
B7109 | 2015-03-22 00:00:00 | 225 | Danville | IL | 136.08 | Y
B4463 | 2015-02-07 00:00:00 | 325 | Anaheim | CA | 445.9
B7109 | 2015-02-25 00:00:00 | 375 | Dallas | TX | 121.28 | Y
B9269 | 2015-01-09 00:00:00 | 475 | Danville | IL | 239.4
B6655 | 2015-03-09 00:00:00 | 250 | Nashville | KY | 306.25
B8353 | 2015-04-17 00:00:00 | 200 | Miami | FL | 420
B7977 | 2015-03-31 00:00:00 | 175 | New York | NY | 302.4
B8353 | 2015-03-07 00:00:00 | 225 | Columbus | OH | 370.44 | Y
B5479 | 2015-04-16 00:00:00 | 475 | Dallas | TX | 199.5
B9269 | 2015-04-24 00:00:00 | 75 | Oklahoma City | OK | 18.9
B3726 | 2015-03-19 00:00:00 | 200 | Anaheim | CA | 112
B4463 | 2015-03-21 00:00:00 | 275 | Oklahoma City | OK | 23.1
B6655 | 2015-01-14 00:00:00 | 350 | Nashville | KY | 275.63
B6655 | 2015-04-17 00:00:00 | 225 | San Francisco | CA | 288
B5543 | 2015-07-21 00:00:00 | 100 | Oklahoma City | OK | 24
B3726 | 2015-07-24 00:00:00 | 125 | Columbus | OH | 126
B7109 | 2015-03-05 00:00:00 | 375 | Tampa | FL | 661.5 | Y
B8353 | 2015-04-10 00:00:00 | 425 | Cleveland | OH | 417.69
B8353 | 2015-07-21 00:00:00 | 325 | Miami | FL | 199.06
B3614 | 2015-05-17 00:00:00 | 375 | New York | NY | 744.19 | Y
B5543 | 2015-02-04 00:00:00 | 425 | Miami | FL | 780.94
B5543 | 2015-04-06 00:00:00 | 250 | San Francisco | CA | 441 | Y
B2483 | 2015-06-09 00:00:00 | 175 | San Francisco | CA | 134.4
B2533 | 2015-02-18 00:00:00 | 375 | San Francisco | CA | 210
B7977 | 2015-01-12 00:00:00 | 75 | Columbus | OH | 132.3
B8353 | 2015-03-19 00:00:00 | 475 | Danville | IL | 251.37 | Y