Files

profiledcgina
MGT-820-WorkingwithPivotTablesT5.xlsx

Sheet2

Product Video Camera - Blue
Sum of Returns Column Labels
Row Labels Chicago LA Phoenix Grand Total
1Q/2015 7762 11286 9696 28744
2Q/2015 5740 11640 11876 29256
3Q/2015 31916 16648 30049 78613
4Q/2015 74500 38022 43847 156369
Grand Total 119918 77596 95468 292982

Sheet1

Product City Month-Year Sales Person Revenue Returns
Video Camera - Blue Phoenix 1Q/2015 Jim $100,000 $3,423
Video Camera - Blue Phoenix 1Q/2015 Mary $85,000 $1,425
Video Camera - Green Phoenix 1Q/2015 Ron $150,000 $0
Video Camera - Blue LA 1Q/2015 Fred $100,000 $4,885
Video Camera - Blue LA 1Q/2015 Jayn $85,000 $758
Video Camera - Green LA 1Q/2015 Bruce $150,000 $0
Video Camera - Blue Chicago 1Q/2015 Tim $100,000 $1,423
Video Camera - Blue Chicago 1Q/2015 Wayne $85,000 $2,458
Video Camera - Green Chicago 1Q/2015 Cindy $150,000 $0
Video Camera - Blue Phoenix 1Q/2015 Amy $259,874 $3,423
Video Camera - Blue Phoenix 1Q/2015 Scott $96,000 $1,425
Video Camera - Green Phoenix 1Q/2015 Marvin $123,000 $0
Video Camera - Blue LA 1Q/2015 Tom $236,955 $4,885
Video Camera - Blue LA 1Q/2015 Janet $96,587 $758
Video Camera - Green LA 1Q/2015 Brian $156,235 $0
Video Camera - Blue Chicago 1Q/2015 Dawayne $158,962 $1,423
Video Camera - Blue Chicago 1Q/2015 Denise $96,325 $2,458
Video Camera - Green Chicago 1Q/2015 Kathy $165,452 $0
Video Camera - Blue Phoenix 2Q/2015 Jim $12,500 $1,245
Video Camera - Blue Phoenix 2Q/2015 Mary $75,000 $4,693
Video Camera - Green Phoenix 2Q/2015 Ron $165,000 $0
Video Camera - Blue LA 2Q/2015 Fred $12,500 $1,247
Video Camera - Blue LA 2Q/2015 Jayn $75,000 $4,573
Video Camera - Green LA 2Q/2015 Bruce $165,000 $0
Video Camera - Blue Chicago 2Q/2015 Tim $12,500 $412
Video Camera - Blue Chicago 2Q/2015 Wayne $75,000 $2,458
Video Camera - Green Chicago 2Q/2015 Cindy $165,000 $0
Video Camera - Blue Phoenix 2Q/2015 Amy $124,587 $1,245
Video Camera - Blue Phoenix 2Q/2015 Scott $54,778 $4,693
Video Camera - Green Phoenix 2Q/2015 Marvin $195,004 $0
Video Camera - Blue LA 2Q/2015 Tom $50,654 $1,247
Video Camera - Blue LA 2Q/2015 Janet $120,584 $4,573
Video Camera - Green LA 2Q/2015 Brian $173,547 $0
Video Camera - Blue Chicago 2Q/2015 Dawayne $23,548 $412
Video Camera - Blue Chicago 2Q/2015 Denise $85,000 $2,458
Video Camera - Green Chicago 2Q/2015 Kathy $187,457 $18,000
Video Camera - Blue Phoenix 3Q/2015 Jim $135,000 $5,000
Video Camera - Blue Phoenix 3Q/2015 Mary $70,000 $5,050
Video Camera - Green Phoenix 3Q/2015 Ron $170,000 $8,500
Video Camera - Blue LA 3Q/2015 Fred $135,000 $9,000
Video Camera - Blue LA 3Q/2015 Jayn $70,000 $1,474
Video Camera - Green LA 3Q/2015 Bruce $170,000 $4,500
Video Camera - Blue Chicago 3Q/2015 Tim $135,000 $10,000
Video Camera - Blue Chicago 3Q/2015 Wayne $70,000 $2,458
Video Camera - Green Chicago 3Q/2015 Cindy $170,000 $3,500
Video Camera - Blue Phoenix 3Q/2015 Amy $135,000 $11,499
Video Camera - Blue Phoenix 3Q/2015 Scott $70,000 $8,500
Video Camera - Green Phoenix 3Q/2015 Marvin $170,000 $6,600
Video Camera - Blue LA 3Q/2015 Tom $135,000 $4,700
Video Camera - Blue LA 3Q/2015 Janet $70,000 $1,474
Video Camera - Green LA 3Q/2015 Brian $170,000 $3,500
Video Camera - Blue Chicago 3Q/2015 Dawayne $135,000 $17,000
Video Camera - Blue Chicago 3Q/2015 Denise $70,000 $2,458
Video Camera - Green Chicago 3Q/2015 Kathy $170,000 $9,999
Video Camera - Blue Phoenix 4Q/2015 Jim $150,000 $15,000
Video Camera - Blue Phoenix 4Q/2015 Mary $73,000 $1,147
Video Camera - Green Phoenix 4Q/2015 Ron $180,000 $13,500
Video Camera - Blue LA 4Q/2015 Fred $150,000 $17,000
Video Camera - Blue LA 4Q/2015 Jayn $73,000 $4,573
Video Camera - Green LA 4Q/2015 Bruce $180,000 $9,000
Video Camera - Blue Chicago 4Q/2015 Tim $150,000 $16,500
Video Camera - Blue Chicago 4Q/2015 Wayne $73,000 $7,500
Video Camera - Green Chicago 4Q/2015 Cindy $180,000 $9,500
Video Camera - Blue Phoenix 4Q/2015 Amy $150,000 $16,500
Video Camera - Blue Phoenix 4Q/2015 Scott $73,000 $11,200
Video Camera - Green Phoenix 4Q/2015 Marvin $180,000 $19,500
Video Camera - Blue LA 4Q/2015 Tom $150,000 $8,900
Video Camera - Blue LA 4Q/2015 Janet $73,000 $7,549
Video Camera - Green LA 4Q/2015 Brian $180,000 $9,549
Video Camera - Blue Chicago 4Q/2015 Dawayne $150,000 $37,000
Video Camera - Blue Chicago 4Q/2015 Denise $73,000 $13,500
Video Camera - Green Chicago 4Q/2015 Kathy $180,000 $14,500