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 |