Data
REGION SALES PERSON FIRST NAME SALES PERSON LAST NAME SALES PERSON ID QUARTER APPLES ORANGES MANGOS TOTAL
Central Bob Taylor 1174 1
Central Helen Smith 833 1
Central Jill Johnson 200 1
Central Sally Morton 500 1
Central Sam Becker 800 1
East Abbey Williams 690 1
East John Dower 255 1
East John Wilson 300 1
East Mary Nelson 600 1
East Sarah Taylor 900 1
West Alex Steller 1000 1
West Billy Winchester 1156 1
West Helen Simpson 817 1
West Jack Smith 100 1
West Joe Tanner 400 1
West Peter Graham 700 1
Central Bob Taylor 1174 2
Central Helen Smith 833 2
Central Jill Johnson 200 2
Central Sally Morton 500 2
Central Sam Becker 800 2
East Abbey Williams 690 2
East John Dower 255 2
East John Wilson 300 2
East Mary Nelson 600 2
East Sarah Taylor 900 2
West Alex Steller 1000 2
West Billy Winchester 1156 2
West Helen Simpson 817 2
West Jack Smith 100 2
West Joe Tanner 400 2
West Peter Graham 700 2
Central Bob Taylor 1174 3
Central Helen Smith 833 3
Central Jill Johnson 200 3
Central Sally Morton 500 3
Central Sam Becker 800 3
East Abbey Williams 690 3
East John Dower 255 3
East John Wilson 300 3
East Mary Nelson 600 3
East Sarah Taylor 900 3
West Alex Steller 1000 3
West Billy Winchester 1156 3
West Jack Smith 100 3
West Joe Tanner 400 3
West Peter Graham 700 3
Central Bob Taylor 1174 4
Central Helen Smith 833 4
Central Jill Johnson 200 4
Central Sally Morton 500 4
Central Sam Becker 800 4
East Abbey Williams 690 4
East John Dower 255 4
East John Wilson 300 4
East Mary Nelson 600 4
East Sarah Taylor 900 4
West Alex Steller 1000 4
West Billy Winchester 1156 4
West Helen Simpson 817 4
West Helen Simpson 817 4
West Jack Smith 100 4
West Joe Tanner 400 4
West Peter Graham 700 4
Pivot Table
REGION
 
Details
REGION SALES PERSON FIRST NAME SALES PERSON LAST NAME SALES PERSON ID QUARTER APPLES ORANGES MANGOS TOTAL
Central Bob Taylor 1174 1 1810 2039 1771 5620
Central Helen Smith 833 1 102 354 59 516
Central Jill Johnson 200 1 93 322 54 469
Central Sally Morton 500 1 595 824 556 1975
Central Sam Becker 800 1 863 1092 824 2779