• Author / Uploaded
• Chucho Ospina

Citation preview

Cantidad de Ventas por País y Total de Ventas. País EE.UU. RU Total Result

Sum - Valor del pedido 894,996 333,331 1,228,327

Indicar el número de ventas realizadas por cada vendedor y el promedio total Vendedor Buchanan Callahan Davolio Dodsworth Fuller King Leverling Peacock Suyama Total Result Valor del pedido

Count - Valor del pedido

Sum - Valor del pedido Vendedor Peacock

País EE.UU.

Sum - Valor del pedido Vendedor Buchanan

País EE.UU.

42 99 117 41 92 67 125 151 65 799 - all -

RU 225,764

RU 68,792

Indicar todas las ventas mensuales del 2009 y 2010. Sum - Valor del pedido Fecha del pedido Jan Feb Mar Apr May Jun Jul Aug Sep Oct

Years 2009

2010 2011 65,090 83,308 31,442 115,149 47,514 77,530 31,596 142,902 63,975 6,932 50,083 20,710 37,545 25,245 56,268 18,030 50,507 43,692 74,305

Nov Dec

39,461 40,443 46,179 60,420

País RU RU EE.UU. EE.UU. EE.UU. EE.UU. RU RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU RU EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. RU RU EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. RU EE.UU. EE.UU.

Vendedor Buchanan Suyama Peacock Leverling Peacock Leverling Buchanan Dodsworth Leverling Peacock Davolio Peacock Peacock Peacock Callahan Dodsworth Suyama Fuller Leverling Peacock Callahan Buchanan Davolio Suyama Suyama Leverling Suyama Davolio Callahan Fuller Callahan Callahan Fuller Peacock Peacock Leverling Peacock Davolio Callahan Callahan Peacock King Callahan Suyama Davolio Davolio

Valor del pedido 440 1,863 1,553 654 3,598 1,445 557 2,491 518 1,120 1,615 101 1,505 448 584 1,874 696 1,176 347 3,537 1,101 642 1,376 48 1,456 2,037 539 292 420 1,201 1,489 351 613 87 155 1,415 1,170 1,743 3,016 819 80 479 2,169 498 1,296 849

Fecha del pedido 7/16/2009 7/10/2009 7/12/2009 7/15/2009 7/11/2009 7/16/2009 7/23/2009 7/15/2009 7/17/2009 7/22/2009 7/23/2009 7/25/2009 7/29/2009 7/30/2009 7/25/2009 7/31/2009 8/23/2009 8/12/2009 7/31/2009 8/6/2009 8/2/2009 8/9/2009 8/2/2009 8/30/2009 8/6/2009 8/12/2009 8/16/2009 8/9/2009 8/14/2009 8/13/2009 8/16/2009 8/16/2009 9/12/2009 8/21/2009 8/21/2009 8/23/2009 8/27/2009 8/26/2009 8/30/2009 8/28/2009 9/3/2009 8/28/2009 9/3/2009 9/4/2009 9/2/2009 9/11/2009

Id Pedido 10248 10249 10250 10251 10252 10253 10254 10255 10256 10257 10258 10259 10260 10261 10262 10263 10264 10265 10266 10267 10268 10269 10270 10271 10272 10273 10274 10275 10276 10277 10278 10279 10280 10281 10282 10283 10284 10285 10286 10287 10288 10289 10290 10291 10292 10293

Construir a partir de lo muestren la siguiente in

Tabla dinámica 1: Ca

Tabla dinámica 2: Ind vendedor y el promedio

Tabla dinámica 3: Ind vendedor.

Tabla dinámica 4: Ind

EE.UU. EE.UU. RU RU RU EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. RU RU EE.UU. RU EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. RU EE.UU. RU RU EE.UU. EE.UU. EE.UU. EE.UU. RU

Peacock Fuller Suyama Buchanan Suyama Peacock Fuller Callahan Peacock King Davolio Callahan Davolio Fuller King Leverling Callahan Davolio Fuller Fuller Davolio Peacock Davolio Suyama Callahan King Buchanan Leverling King Peacock Dodsworth Davolio Peacock Fuller Peacock Peacock Leverling Dodsworth Leverling Buchanan Callahan King King Peacock Peacock Fuller Davolio King

1,888 122 1,051 1,420 2,645 350 608 755 2,709 1,118 954 3,741 499 424 89 1,762 336 269 1,615 182 2,094 517 2,835 288 240 1,191 516 144 112 164 5,276 1,497 982 1,810 1,168 4,578 1,649 89 1,787 877 145 2,036 285 2,467 935 3,354 2,436 353

9/5/2009 9/10/2009 9/11/2009 9/10/2009 9/11/2009 9/13/2009 9/18/2009 9/17/2009 10/9/2009 9/18/2009 9/17/2009 10/9/2009 9/23/2009 9/25/2009 9/24/2009 10/23/2009 9/27/2009 9/26/2009 10/3/2009 10/4/2009 10/4/2009 10/3/2009 10/8/2009 10/10/2009 10/4/2009 10/11/2009 10/18/2009 10/11/2009 10/23/2009 10/14/2009 10/10/2009 10/14/2009 10/14/2009 10/14/2009 10/17/2009 10/23/2009 10/28/2009 10/21/2009 10/21/2009 10/25/2009 10/28/2009 10/24/2009 10/25/2009 10/29/2009 10/29/2009 11/4/2009 11/8/2009 11/5/2009

10294 10295 10296 10297 10298 10299 10300 10301 10302 10303 10304 10305 10306 10307 10308 10309 10310 10311 10312 10313 10314 10315 10316 10317 10318 10319 10320 10321 10322 10323 10324 10325 10326 10327 10328 10329 10330 10331 10332 10333 10334 10335 10336 10337 10338 10339 10340 10341

EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU RU EE.UU. EE.UU. RU EE.UU. RU RU EE.UU. RU RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. RU EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU.

Peacock Peacock Peacock Fuller Leverling Peacock Peacock King Suyama Davolio Leverling King Callahan Suyama Suyama Davolio Buchanan Buchanan Peacock Davolio Leverling Peacock Davolio Leverling Callahan King Fuller Callahan Suyama Davolio Buchanan Peacock Davolio Leverling Davolio Davolio Buchanan Fuller Callahan Leverling Peacock Callahan Leverling Davolio Dodsworth Davolio Fuller Peacock

1,841 1,584 2,296 2,925 1,619 814 364 142 642 5,399 136 8,593 569 480 1,106 1,168 429 3,472 7,390 2,046 1,550 447 950 403 136 834 1,690 2,390 1,118 73 9,211 1,366 459 338 399 864 103 863 1,314 112 2,900 899 2,222 691 166 1,058 1,229 1,833

11/4/2009 11/6/2009 11/5/2009 11/11/2009 11/8/2009 11/8/2009 11/15/2009 11/15/2009 12/3/2009 11/20/2009 11/18/2009 11/25/2009 11/20/2009 11/20/2009 11/27/2009 12/2/2009 11/27/2009 11/26/2009 12/2/2009 12/3/2009 11/28/2009 12/4/2009 12/4/2009 12/2/2009 12/30/2009 12/2/2009 12/2/2009 12/9/2009 12/27/2009 12/24/2009 12/9/2009 12/11/2009 12/9/2009 12/9/2009 12/13/2009 12/13/2009 12/19/2009 12/13/2009 1/16/2010 12/13/2009 12/16/2009 12/18/2009 12/20/2009 12/23/2009 12/25/2009 12/20/2009 12/20/2009 12/24/2009

10342 10343 10344 10345 10346 10347 10348 10349 10350 10351 10352 10353 10354 10355 10356 10357 10358 10359 10360 10361 10362 10363 10364 10365 10366 10367 10368 10369 10370 10371 10372 10373 10374 10375 10376 10377 10378 10379 10380 10381 10382 10383 10384 10385 10386 10387 10388 10389

RU EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU RU RU EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU.

Suyama Leverling Fuller Davolio Davolio Suyama Davolio Buchanan Fuller Callahan Davolio Davolio Callahan Peacock Fuller Davolio King Fuller Callahan Leverling Leverling Dodsworth Callahan Leverling Fuller Leverling Callahan Peacock Peacock Peacock Leverling Callahan Fuller Suyama King Suyama Peacock Peacock King Leverling Peacock Peacock Leverling Leverling Leverling Callahan Leverling Callahan

2,091 86 1,440 2,557 442 2,123 1,904 717 2,506 1,766 3,063 3,869 2,714 855 1,591 400 1,831 1,194 1,622 319 802 967 335 2,123 225 102 720 11,188 1,815 2,098 1,708 1,194 50 1,020 9,195 360 338 651 192 1,441 4,899 1,892 485 851 321 632 1,995 393

12/26/2009 12/31/2009 1/1/2010 1/3/2010 1/3/2010 1/3/2010 1/6/2010 1/2/2010 1/9/2010 1/8/2010 1/16/2010 1/10/2010 1/10/2010 1/9/2010 1/8/2010 1/22/2010 1/13/2010 1/30/2010 1/14/2010 1/14/2010 1/15/2010 1/21/2010 1/15/2010 1/16/2010 1/17/2010 1/24/2010 1/27/2010 1/28/2010 1/24/2010 1/30/2010 1/27/2010 1/27/2010 1/31/2010 2/24/2010 1/27/2010 2/14/2010 2/6/2010 3/3/2010 2/4/2010 2/7/2010 2/3/2010 2/7/2010 2/7/2010 3/4/2010 2/13/2010 2/7/2010 2/11/2010 2/12/2010

10390 10391 10392 10393 10394 10395 10396 10397 10398 10399 10400 10401 10402 10403 10404 10405 10406 10407 10408 10409 10410 10411 10412 10413 10414 10415 10416 10417 10418 10419 10420 10421 10422 10423 10424 10425 10426 10427 10428 10429 10430 10431 10432 10433 10434 10435 10436 10437

EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU RU EE.UU. RU EE.UU. EE.UU. RU EE.UU. EE.UU. RU EE.UU. EE.UU.

Leverling Suyama Peacock Leverling Leverling Callahan Leverling Leverling Suyama Peacock Peacock Leverling Callahan Peacock Callahan Davolio Peacock Callahan Callahan Fuller King Peacock Callahan Davolio Fuller Buchanan Peacock Davolio Peacock Callahan Leverling Davolio Peacock Fuller Callahan Davolio Buchanan Dodsworth Callahan Buchanan Fuller Leverling Suyama Callahan Davolio King Leverling Peacock

454 1,078 4,924 1,755 1,792 517 1,032 175 246 914 443 1,838 425 3,850 2,019 408 331 2,684 558 1,584 3,891 1,659 176 1,539 156 713 1,609 2,518 216 235 718 957 1,821 1,328 1,037 230 1,249 1,505 180 558 471 10,496 756 1,472 147 669 386 1,584

2/14/2010 2/10/2010 2/28/2010 3/14/2010 2/18/2010 2/14/2010 2/21/2010 2/20/2010 2/19/2010 3/7/2010 2/24/2010 2/27/2010 3/11/2010 3/12/2010 2/26/2010 2/26/2010 2/25/2010 3/3/2010 2/28/2010 3/3/2010 3/4/2010 2/28/2010 3/3/2010 3/5/2010 3/18/2010 3/6/2010 3/14/2010 3/14/2010 3/13/2010 3/11/2010 3/12/2010 3/14/2010 3/14/2010 3/18/2010 3/19/2010 3/21/2010 3/21/2010 4/4/2010 3/24/2010 3/25/2010 3/26/2010 3/21/2010 3/24/2010 3/25/2010 4/10/2010 4/25/2010 4/1/2010 3/31/2010

10438 10439 10440 10441 10442 10443 10444 10445 10446 10447 10448 10449 10450 10451 10452 10453 10454 10455 10456 10457 10458 10459 10460 10461 10462 10463 10464 10465 10466 10467 10468 10469 10470 10471 10472 10473 10474 10475 10476 10477 10478 10479 10480 10481 10482 10483 10484 10485

EE.UU. EE.UU. EE.UU. RU RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU RU EE.UU. EE.UU. RU RU EE.UU. RU EE.UU. EE.UU. RU RU EE.UU. EE.UU. RU EE.UU. RU RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU RU EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. RU RU RU EE.UU. RU RU EE.UU.

Davolio Fuller Callahan Suyama King Callahan Leverling Peacock Peacock Leverling King King Callahan Peacock Suyama Dodsworth Fuller Suyama Peacock Leverling Dodsworth King Davolio Peacock Suyama Peacock King King Leverling Fuller Fuller Leverling Peacock Suyama King Callahan Peacock King Davolio Davolio Peacock King Suyama Buchanan Leverling King King Callahan

1,272 890 1,512 439 3,163 260 851 608 912 278 190 1,381 575 1,412 523 149 816 2,049 1,389 148 416 749 240 137 4,708 2,550 525 1,942 8,623 9,921 2,381 352 4,150 2,314 200 226 2,318 2,444 3,193 818 1,151 1,503 392 946 4,180 110 796 2,222

4/2/2010 3/28/2010 4/2/2010 4/9/2010 4/3/2010 4/8/2010 4/11/2010 4/10/2010 4/9/2010 4/11/2010 4/7/2010 4/7/2010 4/11/2010 4/16/2010 4/17/2010 4/16/2010 4/29/2010 4/16/2010 4/18/2010 4/21/2010 5/2/2010 4/22/2010 5/13/2010 4/29/2010 4/28/2010 4/21/2010 4/24/2010 4/28/2010 5/16/2010 5/23/2010 5/1/2010 4/29/2010 5/5/2010 5/1/2010 5/1/2010 5/2/2010 5/6/2010 5/30/2010 5/7/2010 5/23/2010 5/15/2010 5/7/2010 5/9/2010 5/9/2010 5/12/2010 5/19/2010 5/12/2010 5/22/2010

10486 10487 10488 10489 10490 10491 10492 10493 10494 10495 10496 10497 10498 10499 10500 10501 10502 10503 10504 10505 10506 10507 10508 10509 10510 10511 10512 10513 10514 10515 10516 10517 10518 10519 10520 10521 10522 10523 10524 10525 10526 10527 10528 10529 10530 10531 10532 10533

EE.UU. EE.UU. EE.UU. EE.UU. RU RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU RU EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. RU EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. RU EE.UU. RU EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU.

Callahan Peacock Leverling Davolio Dodsworth Suyama Leverling Fuller Davolio Callahan Peacock Callahan Davolio Leverling Leverling Buchanan King Peacock Fuller Fuller Peacock Suyama Fuller Dodsworth Davolio Suyama Callahan Fuller Davolio Fuller Peacock Callahan Dodsworth Davolio Leverling Buchanan Leverling Callahan Leverling King Peacock Buchanan Leverling Dodsworth Peacock Davolio Peacock Leverling

466 1,941 1,645 1,824 140 356 10,192 1,947 469 1,505 417 210 2,812 1,793 240 3,554 683 1,677 881 1,546 1,729 2,944 835 1,153 2,143 520 1,072 2,845 489 965 1,234 640 1,761 2,519 155 890 2,465 551 1,501 2,082 764 2,147 838 569 477 318 1,014 310

5/14/2010 5/21/2010 6/6/2010 5/19/2010 5/16/2010 5/23/2010 6/13/2010 5/29/2010 5/26/2010 5/23/2010 5/30/2010 6/26/2010 5/27/2010 6/2/2010 6/2/2010 5/30/2010 6/6/2010 6/6/2010 6/5/2010 6/3/2010 6/5/2010 6/4/2010 6/13/2010 6/6/2010 6/10/2010 6/13/2010 6/9/2010 6/9/2010 6/12/2010 6/24/2010 6/16/2010 6/18/2010 6/18/2010 6/17/2010 7/9/2010 7/11/2010 6/19/2010 7/4/2010 6/25/2010 6/20/2010 6/30/2010 6/30/2010 6/30/2010 6/30/2010 7/25/2010 7/4/2010 7/1/2010 7/2/2010

10534 10535 10536 10537 10538 10539 10540 10541 10542 10543 10544 10545 10546 10547 10548 10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581

EE.UU. EE.UU. EE.UU. RU RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. RU EE.UU. RU EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. RU EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU.

Leverling Fuller Peacock King Dodsworth Davolio Fuller Callahan Peacock Davolio Leverling King Leverling Fuller Callahan King Davolio Suyama Peacock King Callahan Callahan Davolio Davolio Peacock Buchanan Peacock King Callahan Suyama Davolio Peacock Callahan Fuller Davolio Peacock Davolio Leverling Fuller Peacock Peacock Callahan Peacock Leverling Davolio Callahan Peacock Peacock

330 2,238 594 143 24 807 3,120 72 1,101 813 516 1,994 566 4,725 1,181 718 2,389 493 480 2,285 49 1,483 231 4,110 1,130 6,475 1,064 424 299 808 6,375 353 464 120 4,807 1,403 2,698 1,260 58 759 560 1,337 1,393 480 1,504 1,186 450 2,775

7/14/2010 7/4/2010 7/4/2010 7/10/2010 7/9/2010 7/9/2010 7/10/2010 7/14/2010 7/14/2010 7/16/2010 7/16/2010 8/13/2010 7/16/2010 7/14/2010 8/12/2010 7/18/2010 7/18/2010 7/21/2010 7/21/2010 7/22/2010 7/22/2010 8/8/2010 7/29/2010 7/29/2010 7/31/2010 7/25/2010 8/1/2010 7/30/2010 8/6/2010 8/1/2010 8/1/2010 8/1/2010 8/1/2010 8/6/2010 8/5/2010 8/4/2010 8/8/2010 8/7/2010 8/14/2010 8/11/2010 8/11/2010 8/12/2010 8/19/2010 8/14/2010 8/20/2010 8/21/2010 8/20/2010 8/20/2010

10582 10583 10584 10585 10586 10587 10588 10589 10590 10591 10592 10593 10594 10595 10596 10597 10598 10599 10600 10601 10602 10603 10604 10605 10606 10607 10608 10609 10610 10611 10612 10613 10614 10615 10616 10617 10618 10619 10620 10621 10622 10623 10624 10625 10626 10627 10628 10629

EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. RU EE.UU. RU EE.UU. EE.UU. RU RU EE.UU. EE.UU. RU EE.UU. RU RU RU EE.UU. EE.UU. EE.UU. RU EE.UU. RU EE.UU. EE.UU. RU EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. RU RU EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. RU EE.UU. EE.UU.

Davolio Callahan Callahan King Peacock Callahan Peacock Suyama Leverling King Peacock Peacock King Suyama Leverling Peacock Dodsworth Peacock Buchanan Buchanan Buchanan Callahan Peacock Davolio Buchanan Davolio Suyama Fuller Peacock King Callahan King Leverling Fuller Davolio Davolio King King Davolio Fuller Peacock Davolio Dodsworth Fuller Peacock Buchanan Fuller Davolio

904 56 589 5,511 4,986 1,326 630 2,762 2,720 500 709 2,054 696 815 1,372 1,535 1,446 636 372 1,434 1,779 398 319 1,083 602 154 604 4,372 4,465 1,227 1,701 563 125 1,930 1,288 1,295 4,667 1,537 625 570 2,302 920 3,815 412 45 1,423 535 813

8/19/2010 8/15/2010 8/19/2010 8/18/2010 8/21/2010 8/21/2010 8/26/2010 8/26/2010 9/1/2010 8/27/2010 8/28/2010 8/26/2010 9/5/2010 9/2/2010 9/1/2010 9/2/2010 9/3/2010 9/3/2010 9/9/2010 8/29/2010 9/3/2010 9/11/2010 9/8/2010 9/19/2010 9/11/2010 9/11/2010 9/10/2010 9/15/2010 9/8/2010 9/10/2010 10/15/2010 9/15/2010 9/18/2010 10/3/2010 9/19/2010 9/17/2010 9/22/2010 9/19/2010 9/23/2010 9/22/2010 9/18/2010 9/24/2010 9/26/2010 9/19/2010 9/30/2010 9/23/2010 9/29/2010 9/26/2010

10630 10631 10632 10633 10634 10635 10636 10637 10638 10639 10640 10641 10642 10643 10644 10645 10646 10647 10648 10649 10650 10651 10652 10653 10654 10655 10656 10657 10658 10659 10660 10661 10662 10663 10664 10665 10666 10667 10668 10669 10670 10671 10672 10673 10674 10675 10676 10677

RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. RU RU RU EE.UU. EE.UU. RU EE.UU. EE.UU. RU EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU.

King Callahan Davolio Leverling Leverling Fuller Leverling Peacock Fuller Dodsworth Peacock Davolio Davolio Fuller Peacock Leverling Callahan King Callahan Leverling Peacock Leverling Leverling Suyama Peacock Suyama Suyama Dodsworth Callahan Peacock Suyama Davolio Davolio Buchanan Leverling Davolio Buchanan Leverling Peacock Davolio Davolio Callahan Callahan Buchanan Callahan Leverling Callahan Peacock

5,257 660 1,262 1,287 376 63 1,768 801 1,404 4,961 3,161 473 863 10,165 878 2,071 4,825 642 996 805 3,436 114 1,638 2,865 330 2,545 596 378 1,893 1,641 180 3,424 94 4,452 1,233 2,828 2,206 1,296 706 1,271 3,463 844 550 924 1,570 468 639 288

10/16/2010 9/30/2010 9/26/2010 9/30/2010 10/1/2010 10/1/2010 9/30/2010 10/3/2010 10/8/2010 10/30/2010 10/7/2010 10/7/2010 10/3/2010 10/22/2010 10/13/2010 10/10/2010 10/9/2010 10/14/2010 10/14/2010 10/14/2010 10/17/2010 10/13/2010 10/16/2010 10/15/2010 10/21/2010 10/20/2010 11/7/2010 11/18/2010 10/21/2010 10/23/2010 11/5/2010 11/20/2010 10/23/2010 10/29/2010 10/31/2010 10/24/2010 10/27/2010 10/29/2010 10/27/2010 10/29/2010 10/29/2010 11/5/2010 11/5/2010 10/31/2010 11/4/2010 11/25/2010 11/5/2010 11/5/2010

10678 10679 10680 10681 10682 10683 10684 10685 10686 10687 10688 10689 10690 10691 10692 10693 10694 10695 10696 10697 10698 10699 10700 10701 10702 10703 10704 10705 10706 10707 10708 10709 10710 10711 10712 10713 10714 10715 10716 10717 10718 10719 10720 10721 10722 10723 10724 10725

EE.UU. EE.UU. EE.UU. EE.UU. RU RU EE.UU. EE.UU. EE.UU. RU RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU RU EE.UU. RU EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU.

Peacock Fuller Peacock Callahan Buchanan King Leverling Davolio Fuller Suyama Dodsworth Fuller Fuller Leverling Peacock Peacock Leverling Davolio Suyama Dodsworth Davolio Suyama Leverling Peacock Dodsworth Leverling Fuller Leverling Suyama Peacock Callahan Suyama Leverling Leverling Peacock Buchanan Leverling Leverling Suyama Leverling Peacock Peacock Leverling Leverling Callahan Dodsworth Leverling Davolio

655 1,625 1,297 1,850 484 1,891 360 1,459 1,498 536 997 140 52 240 1,416 228 3,118 319 736 4,530 2,312 1,913 2,196 1,080 1,591 1,631 252 88 55 1,949 1,990 3,082 1,645 320 2,917 507 4,337 616 2,286 1,516 2,310 28 1,477 1,684 236 344 3,603 2,030

12/5/2010 12/5/2010 11/11/2010 11/14/2010 11/14/2010 11/14/2010 11/7/2010 11/10/2010 11/12/2010 11/21/2010 11/21/2010 11/18/2010 11/18/2010 11/17/2010 11/25/2010 11/18/2010 11/18/2010 11/21/2010 11/24/2010 11/27/2010 11/21/2010 11/26/2010 11/28/2010 12/19/2010 11/24/2010 12/3/2010 11/28/2010 11/27/2010 11/27/2010 11/28/2010 12/2/2010 12/15/2010 12/4/2010 12/12/2010 12/10/2010 12/8/2010 12/9/2010 12/8/2010 12/8/2010 12/9/2010 12/9/2010 12/15/2010 12/15/2010 12/12/2010 12/17/2010 1/2/2010 12/19/2010 12/16/2010

10726 10727 10728 10729 10730 10731 10732 10733 10734 10735 10736 10737 10738 10739 10740 10741 10742 10743 10744 10745 10746 10747 10748 10749 10750 10751 10752 10753 10754 10755 10756 10757 10758 10759 10760 10761 10762 10763 10764 10765 10766 10767 10768 10769 10770 10771 10772 10773

EE.UU. RU EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU RU EE.UU. EE.UU. RU EE.UU. EE.UU. RU EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU.

Peacock King Davolio King Leverling Leverling Fuller Fuller Dodsworth Peacock Peacock Davolio Callahan Fuller Davolio Davolio Suyama Suyama Davolio Leverling Suyama Callahan Leverling King Fuller Dodsworth Davolio Peacock Peacock Peacock Suyama Fuller Leverling Peacock Fuller King Fuller Callahan Buchanan Davolio Leverling Fuller Peacock Leverling King Fuller Leverling Davolio

869 228 6,635 224 97 1,335 720 976 13 1,443 1,488 388 1,531 2,623 732 3,687 723 1,830 400 191 315 2,158 2,341 420 447 1,554 1,469 3,027 2,943 1,193 2,278 2,775 440 18 1,411 140 187 852 1,693 602 1,788 40 8,446 10,953 833 477 1,140 678

12/12/2010 12/26/2010 12/18/2010 1/21/2011 12/24/2010 1/14/2011 12/25/2010 12/19/2010 12/22/2010 12/19/2010 12/22/2010 12/24/2010 12/23/2010 12/26/2010 1/19/2011 12/31/2010 12/26/2010 1/1/2011 12/31/2010 1/8/2011 1/2/2011 1/20/2011 1/14/2011 1/5/2011 1/5/2011 1/5/2011 1/5/2011 12/31/2010 1/2/2011 1/6/2011 1/7/2011 1/9/2011 1/5/2011 1/30/2011 1/9/2011 1/7/2011 1/7/2011 1/8/2011 1/12/2011 1/9/2011 1/14/2011 1/14/2011 2/4/2011 1/13/2011 1/12/2011 1/16/2011 1/13/2011 1/15/2011

10774 10775 10776 10777 10778 10779 10780 10781 10782 10783 10784 10785 10786 10787 10788 10789 10790 10791 10792 10793 10794 10795 10796 10797 10798 10799 10800 10801 10802 10803 10804 10805 10806 10807 10808 10809 10810 10811 10812 10813 10814 10815 10816 10817 10818 10819 10820 10821

RU RU EE.UU. EE.UU. RU EE.UU. RU RU EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. RU RU EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU RU EE.UU. RU EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU RU RU RU

Suyama Buchanan Callahan Davolio Suyama Davolio Dodsworth Dodsworth Peacock Leverling Fuller Suyama Davolio Davolio King Dodsworth Leverling Leverling Peacock Buchanan Davolio Peacock Callahan Callahan Fuller Peacock King Dodsworth Davolio Buchanan Callahan Dodsworth Leverling Leverling Leverling Callahan Fuller Davolio Leverling Peacock Callahan Peacock Peacock Fuller Buchanan Suyama King Buchanan

238 2,826 251 1,031 730 843 932 1,764 1,974 2,684 475 907 1,433 846 4,706 1,065 1,938 828 211 4,581 975 159 735 3,813 1,112 4,932 932 968 629 2,603 2,984 625 2,967 2,228 660 2,048 649 1,079 519 3,523 581 441 282 16,388 1,096 98 1,921 1,630

1/16/2011 1/13/2011 1/30/2011 1/14/2011 2/6/2011 2/6/2011 2/4/2011 1/23/2011 1/21/2011 1/23/2011 1/19/2011 1/23/2011 1/19/2011 1/21/2011 1/21/2011 1/23/2011 1/23/2011 1/22/2011 2/16/2011 1/29/2011 1/29/2011 1/26/2011 1/26/2011 1/30/2011 1/23/2011 2/10/2011 1/29/2011 1/30/2011 1/30/2011 2/2/2011 1/30/2011 2/3/2011 2/5/2011 2/4/2011 2/10/2011 2/6/2011 2/3/2011 2/2/2011 2/4/2011 2/17/2011 2/2/2011 2/17/2011 2/9/2011 2/12/2011 2/12/2011 2/11/2011 2/23/2011 2/9/2011

10822 10823 10824 10825 10826 10827 10828 10829 10830 10831 10832 10833 10834 10835 10836 10837 10838 10839 10840 10841 10842 10843 10844 10845 10846 10847 10848 10849 10850 10851 10852 10853 10854 10855 10856 10857 10858 10859 10860 10861 10862 10863 10864 10865 10866 10867 10868 10869

RU RU RU EE.UU. RU EE.UU. RU EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. RU RU RU EE.UU. RU EE.UU. EE.UU. RU EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU.

Buchanan Dodsworth Buchanan Peacock Buchanan Peacock King Davolio Peacock Leverling King Peacock Peacock Callahan Peacock Suyama Davolio Callahan Davolio Dodsworth King King Peacock Dodsworth Davolio Leverling King Leverling Peacock Buchanan Davolio Peacock Davolio Leverling Leverling Dodsworth Peacock Suyama Peacock Davolio Davolio Leverling Fuller Peacock Suyama Fuller Davolio Peacock

160 1,979 2,058 337 310 710 917 1,955 1,539 611 1,500 150 893 36 1,378 1,209 3,128 70 605 11,380 860 369 2,090 5,502 2,753 6,379 751 10,835 30 122 34 935 863 932 1,924 342 428 109 663 670 453 858 6,201 769 538 540 687 366

2/13/2011 2/10/2011 2/9/2011 2/9/2011 2/11/2011 3/3/2011 2/12/2011 2/19/2011 2/12/2011 2/12/2011 2/18/2011 2/18/2011 2/20/2011 2/20/2011 2/13/2011 2/18/2011 3/2/2011 2/16/2011 2/23/2011 2/23/2011 2/18/2011 2/19/2011 2/19/2011 2/20/2011 2/20/2011 2/23/2011 2/27/2011 2/25/2011 3/6/2011 2/26/2011 3/4/2011 2/26/2011 3/3/2011 3/4/2011 2/27/2011 3/6/2011 3/3/2011 2/27/2011 3/6/2011 3/10/2011 3/4/2011 3/5/2011 3/18/2011 3/4/2011 3/2/2011 3/2/2011 3/9/2011 3/11/2011

10870 10871 10872 10873 10874 10875 10876 10877 10878 10879 10880 10881 10882 10883 10884 10885 10886 10887 10888 10889 10890 10891 10892 10893 10894 10895 10896 10897 10898 10899 10900 10901 10902 10903 10904 10905 10906 10907 10908 10909 10910 10911 10912 10913 10914 10915 10916 10917

EE.UU. EE.UU. EE.UU. EE.UU. RU RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. RU RU EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. RU RU EE.UU. RU EE.UU. RU RU EE.UU. EE.UU. EE.UU. RU EE.UU. RU

Leverling Fuller Peacock Davolio Buchanan King Leverling Leverling Peacock Peacock Davolio Suyama Peacock Peacock Callahan Suyama Leverling Peacock Leverling King Leverling Fuller Callahan King Dodsworth Peacock Suyama Peacock Davolio Leverling Leverling Fuller Davolio Dodsworth Davolio Dodsworth Buchanan Callahan Suyama Callahan King Suyama Leverling Callahan Callahan Dodsworth Leverling Suyama

1,448 1,123 390 1,936 743 749 1,836 475 514 800 138 1,175 2,256 799 1,789 921 500 620 456 645 2,732 638 360 4,012 560 711 1,025 245 1,408 220 2,362 4,422 110 459 471 4,441 1,660 74 677 1,763 781 132 265 1,120 3,584 58 2,053 848

3/11/2011 3/4/2011 3/9/2011 3/9/2011 3/5/2011 3/13/2011 4/8/2011 3/13/2011 3/11/2011 4/8/2011 3/18/2011 3/12/2011 3/18/2011 3/19/2011 3/24/2011 3/16/2011 3/12/2011 3/18/2011 3/18/2011 3/13/2011 3/16/2011 3/13/2011 3/23/2011 3/20/2011 3/18/2011 3/19/2011 3/13/2011 3/18/2011 3/19/2011 3/16/2011 3/19/2011 3/17/2011 3/23/2011 4/7/2011 3/24/2011 3/25/2011 3/20/2011 3/20/2011 3/20/2011 3/27/2011 3/27/2011 3/23/2011 4/8/2011 3/30/2011 3/23/2011 3/26/2011 3/24/2011 3/30/2011

10918 10919 10920 10921 10922 10923 10924 10925 10926 10927 10928 10929 10930 10931 10932 10933 10934 10935 10936 10937 10938 10939 10940 10941 10942 10943 10944 10945 10946 10947 10948 10949 10950 10951 10952 10953 10954 10955 10956 10957 10958 10959 10960 10961 10962 10963 10964 10965

EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. EE.UU.

Peacock Fuller Davolio Davolio Dodsworth Fuller Peacock Suyama Leverling Davolio Davolio Callahan Dodsworth Callahan Peacock Davolio Fuller Fuller Davolio Fuller Callahan Callahan Leverling Fuller Fuller Davolio Davolio King Fuller Davolio Peacock Callahan Callahan Suyama Fuller Fuller Peacock Leverling Leverling Fuller Leverling Callahan Fuller Fuller Leverling Davolio Fuller Fuller

1,098 910 1,408 108 224 1,733 252 292 439 718 912 2,233 1,303 4,814 248 15,810 1,014 721 1,810 2,023 2,220 2,772 3,575 1,354 4,289 2,296 70 4,895 941 1,196 560 1,885 686 1,198 904 2,769 1,811 326 295 586 330 2,634 617 645 934 2,825 361 243

4/8/2011 4/2/2011 4/1/2011 3/30/2011 4/24/2011 4/2/2011 3/26/2011 3/27/2011 4/3/2011 3/27/2011 4/3/2011 4/10/2011 4/23/2011 3/31/2011 4/17/2011 4/2/2011 4/8/2011 4/6/2011 4/3/2011 4/2/2011 4/21/2011 4/6/2011 4/10/2011 4/2/2011 4/7/2011 4/7/2011 4/3/2011 4/10/2011 4/9/2011 4/6/2011 4/10/2011 4/13/2011 4/17/2011 4/10/2011 4/14/2011 4/14/2011 4/16/2011 4/8/2011 4/20/2011 4/10/2011 4/15/2011 4/13/2011 4/10/2011 4/21/2011 4/13/2011 4/17/2011 4/10/2011 4/15/2011

10966 10967 10968 10969 10970 10971 10972 10973 10974 10975 10976 10977 10978 10979 10980 10981 10982 10983 10984 10985 10986 10987 10988 10989 10990 10991 10992 10993 10994 10995 10996 10997 10998 10999 11000 11001 11002 11003 11004 11005 11006 11007 11009 11010 11011 11012 11013 11014

EE.UU. RU RU EE.UU. EE.UU. EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. EE.UU. RU RU EE.UU. RU EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. EE.UU. RU EE.UU. EE.UU. RU RU EE.UU. EE.UU. EE.UU. EE.UU.

Fuller Dodsworth Dodsworth Peacock Fuller Leverling Davolio Peacock Suyama Peacock Davolio Fuller Peacock King Suyama Fuller King Callahan Fuller Callahan King Davolio Leverling Fuller Buchanan Peacock Callahan King King Leverling Fuller Callahan Leverling

622 492 6,750 1,575 632 6,306 1,500 1,967 270 1,030 878 2,160 1,287 12,615 2,394 8,903 3,233 539 1,755 1,692 60 733 1,773 406 210 592 1,486 818 525 1,332 3,055 3,740 45

4/20/2011 4/13/2011 4/20/2011 4/16/2011 4/16/2011 4/21/2011 4/24/2011 4/20/2011 4/24/2011 4/28/2011 4/20/2011 4/22/2011 4/27/2011 4/27/2011 4/24/2011 4/23/2011 4/23/2011 4/27/2011 4/24/2011 4/22/2011 4/27/2011 4/30/2011 4/28/2011 5/1/2011 4/29/2011 5/1/2011 4/24/2011 5/1/2011 4/30/2011 5/1/2011 4/29/2011 5/1/2011 5/1/2011

11015 11016 11017 11018 11020 11021 11023 11024 11025 11026 11027 11028 11029 11030 11031 11032 11033 11034 11035 11036 11037 11038 11041 11042 11043 11044 11046 11047 11048 11052 11053 11056 11057

Construir a partir de los siguientes datos, las tablas dinámicas que muestren la siguiente información: Tabla dinámica 1: Cantidad de Ventas por País y Total de Ventas. Tabla dinámica 2: Indicar el número de ventas realizadas por cada vendedor y el promedio total. Tabla dinámica 3: Indicar las ventas mayores y menores por cada país y vendedor. Tabla dinámica 4: Indicar todas las ventas mensuales del 2009 y 2010.