1. Create a pivot table to answer: Which region is the most profitable?

E F G H H D E Order Amount Month 104 Jan 285 Feb 594 Feb 578 Jan 484 Jan A Salesperson 2 Oprah 3 Oprah 4 Oprah 5 Oprah 6 Lady Gaga 7 Lady Gaga 8 Lady Gaga 9 Spielberg 10 Spielberg 11 Spielberg 12 Spielberg 13 Beyonce 14 Beyonce 15 Beyonce 16 Beyonce 17 Beyonce 18 Beyonce 19 Beyonce 20 Madonna 21 Madonna 22 Madonna 23 Madonna 24 Taylor 25 Taylor 26 Bon Jovi 27 Bon Jovi 28 Bon Jovi 29 Bon Jovi 30 Federer 31 Federer 32 Federer 33 Federer 34 Federer 35 Federer 36 Federer 37 Federer 38 39 B Region M EAST EAST EAST EAST WEST WEST WEST NORTH NORTH NORTH NORTH SOUTH SOUTH SOUTH SOUTH SOUTH SOUTH SOUTH EAST EAST EAST EAST WEST WEST NORTH NORTH NORTH NORTH SOUTH SOUTH SOUTH SOUTH SOUTH SOUTH SOUTH SOUTH Accoun 1051 5967 7384 8822 7711 5627 3017 4605 5040 3309 7292 2728 8798 5351 4308 7130 6687 3374 1123 9475 2380 2900 2263 5828 3175 1465 5440 4426 8241 2173 4217 8016 6486 4705 5261 7236 916 Jan 213 Feb 121 Feb 983 Jan 487 Feb 124 Feb 184 Feb 737 Jan 176 Jan 387 Feb 923 Jan 463 Feb 127 Jan 487 Jan 925 Jan 379 Feb 419 Feb 286 Jan 951 Jan 330 Jan 969 Feb 508 Feb 575 Feb 164 Jan 942 Feb 623 Feb 859 Jan 597 Jan 968 Feb 923 Feb 949 Feb