In: Accounting
Pivot Tables - Please explain how to acheive the following:
Using the data below, create a Pivot Table that answers the question “Which salesperson sold the most in any particular month.” A manager wants to click on the Pivot Table and choose a month and have the name of that person appear with his or her amount for that month.
Sales Data | ||||||
Salesperson | May | June | July | Aug. | Sept. | Oct. |
Albertson, Kathy | $3,947.00 | $557.00 | $3,863.00 | $1,117.00 | $8,237.00 | $8,690.00 |
Allenson, Carol | $4,411.00 | $1,042.00 | $9,355.00 | $1,100.00 | $10,185.00 | $18,749.00 |
Altman, Zoey | $2,521.00 | $3,072.00 | $6,702.00 | $2,116.00 | $13,452.00 | $8,046.00 |
Bittiman, William | $4,752.00 | $3,755.00 | $4,415.00 | $1,089.00 | $4,404.00 | $20,114.00 |
Brennan, Michael | $4,964.00 | $3,152.00 | $11,601.00 | $1,122.00 | $3,170.00 | $10,733.00 |
Carlson, David | $2,327.00 | $4,056.00 | $3,726.00 | $1,135.00 | $8,817.00 | $18,524.00 |
Collman, Harry | $3,967.00 | $4,906.00 | $9,007.00 | $2,113.00 | $13,090.00 | $13,953.00 |
Counts, Elizabeth | $4,670.00 | $521.00 | $4,505.00 | $1,024.00 | $3,528.00 | $15,275.00 |
David, Chloe | $3,379.00 | $3,428.00 | $3,973.00 | $1,716.00 | $4,839.00 | $13,085.00 |
Davis, William | $5,363.00 | $1,562.00 | $2,945.00 | $1,176.00 | $9,642.00 | $13,714.00 |
Dumlao, Richard | $3,275.00 | $2,779.00 | $7,549.00 | $1,101.00 | $5,850.00 | $15,065.00 |
Farmer, Kim | $3,860.00 | $3,470.00 | $3,862.00 | $1,040.00 | $10,024.00 | $18,389.00 |
Ferguson, Elizabeth | $4,685.00 | $1,913.00 | $4,596.00 | $1,126.00 | $5,503.00 | $10,686.00 |
Flores, Tia | $4,052.00 | $2,883.00 | $2,142.00 | $2,012.00 | $13,547.00 | $21,983.00 |
Ford, Victor | $5,541.00 | $4,931.00 | $8,283.00 | $1,054.00 | $9,543.00 | $11,967.00 |
Hodges, Melissa | $5,667.00 | $4,798.00 | $8,420.00 | $1,389.00 | $10,468.00 | $12,677.00 |
Jameson, Robinson | $4,269.00 | $4,459.00 | $2,248.00 | $1,058.00 | $6,267.00 | $14,982.00 |
Kellerman, Frances | $3,502.00 | $4,172.00 | $11,074.00 | $1,282.00 | $2,365.00 | $9,380.00 |
Mark, Katharine | $5,853.00 | $2,011.00 | $3,807.00 | $1,348.00 | $11,110.00 | $18,047.00 |
Morrison, Thomas | $2,586.00 | $2,398.00 | $2,453.00 | $1,020.00 | $4,612.00 | $20,525.00 |
Moss, Pete | $5,714.00 | $4,960.00 | $11,507.00 | $1,010.00 | $6,599.00 | $11,626.00 |
The yellow cell indicates the maximum sales affected by a salesperson in a particular month whereas the red cell indicates the minimum amount of sales affected by a salesperson in a particular month.