Question

In: Accounting

Pivot Tables - Please explain how to acheive the following: Using the data below, create a...

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

Solutions

Expert Solution

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.


Related Solutions

"Analysis via Pivot Tables" Please respond to the following: Describe a situation where pivot tables could...
"Analysis via Pivot Tables" Please respond to the following: Describe a situation where pivot tables could be used to aid a business decision. Specify the question/problem management needs to resolve and explain the manner in which the pivot table results will provide a solution. You may use one (1) of the homework exercises as a basis for your response, or a company with which you are familiar.
Using the sample code included at the end of the document to create the tables, Please...
Using the sample code included at the end of the document to create the tables, Please write an anonymous PL/SQL program the following problems. Problem 1. Print out estimated charge for rental ID 1 if the customer returns the tool in time. The charge is computed by the price in the price_tool table * number of units the customer plans to rent. E.g., if a customer rents a tool hourly for 5 hours, and the hourly rate for the tool...
In MySQL, create a new schema titled <yourlastname>module3. Using the below file, create the tables in...
In MySQL, create a new schema titled <yourlastname>module3. Using the below file, create the tables in your new schema and populate with the supplied data. Tables do not have keys. Do not define them at this time. There are errors in the data population (INSERT) statements. It is your job to find the errors and correct them. This is important. You will need correct data for future exercises in this module. In the submission area, choose Write Submission and identify...
What are some of the limitations of using Excel for pivot tables/charts? Why does that make...
What are some of the limitations of using Excel for pivot tables/charts? Why does that make software like Tableau more appealing in the workplace?
-Using MySQL Workbench Data Modeler, create three (3) models from the tables below. Show Table 1...
-Using MySQL Workbench Data Modeler, create three (3) models from the tables below. Show Table 1 in 3rd Normal Form. Show Table 2 in 3rd Normal Form. Merge the 3rd Normal Forms of Table 1 and Table 2 into a single 3rd Normal Form model. Note that you only can model table and column names and data types. The data shown is for your reference to determine functional, partial, and transitive dependencies. -Provide a summary of the steps you took...
1. Collect annual data to create data tables and graphs of the following: a. growth rates...
1. Collect annual data to create data tables and graphs of the following: a. growth rates of NGDP and RGDP for the years 2008-2018 b. CPI-All Urban Consumers (Current Series) and the inflation rate for the years 2008-2018 c. unemployment rate for the years 2008-2018 d. M1 and M2 for the years 2008-2018
Answer IN R CODE please. Using the data below, Create a scatterplot of y vs x...
Answer IN R CODE please. Using the data below, Create a scatterplot of y vs x (show this) and fit it a simple linear regression model using y as the response and plot the regression line (with the data). Show this as well. Test whether x is a significant predictor and create a 95% CI around the slope coefficient. What does the coefficient of determinations represent? For x=20, create a CI for E(Y|X=20). Show this. For x=150, can you use...
Answer IN R CODE to get the following. Using the data below, Create a scatterplot of...
Answer IN R CODE to get the following. Using the data below, Create a scatterplot of y vs x Fit a simple linear regression model using y as the response and plot the regression line (with the data) Test whether x is a significant predictor and create a 95% CI around the slope coefficient. Report and interpret the coefficient of determination. For x=20, create a CI for E(Y|X=20). For x=150, can you use the model to estimate E(Y|X=150)? Discuss. Does...
Without using Pivot Tables, calculate the Frequency, Relative Frequency, and Percent Frequency for each major. Major...
Without using Pivot Tables, calculate the Frequency, Relative Frequency, and Percent Frequency for each major. Major ECON BIOL CHEM CHEM MKTG CHEM ACCT CHEM MGMT BIOL BIOL IBUS CHEM ACCT FINA CHEM MKTG CHEM PHYS ECON PHYS ECON MKTG ACCT MATH IBUS MATH MGMT ACCT ECON BIOL CHEM PHYS MGMT ACCT ACCT CHEM PHYS ECON ACCT MGMT ECON MGMT MATH ACCT MATH MGMT MATH FINA ACCT CHEM MGMT ECON ECON FINA IBUS MGMT FINA MGMT CHEM ACCT ACCT IBUS MKTG...
Database exercise: inpatient cases Create database using name RUMKIT Create tables below in that database patient(idPatient,...
Database exercise: inpatient cases Create database using name RUMKIT Create tables below in that database patient(idPatient, fullName, biologicalMother, birthdate, address) doctor(idDr, fullName, specialization, consulRates) inpatient(idPatient, entryTime, outTime, idDr, idRoom). Please make entryTime as column that is going to be filled automatically when care record is being add room(idRoom, roomName, cost) fill the data above to each table Create sql query and relational algebra expressions for the query Please give me detailed answer so I could learn from it. Thank you...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT