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.
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?
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...
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...
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...
using C++ Please create the class named BankAccount with the following properties below: // The BankAccount...
using C++ Please create the class named BankAccount with the following properties below: // The BankAccount class sets up a clients account (using name & id), and - keeps track of a user's available balance. - how many transactions (deposits and/or withdrawals) are made. public class BankAccount { private int id; private String name private double balance; private int numTransactions; // ** Please define method definitions for Accessors and Mutators functions below for the class private member variables string getName();...
using the data below create a time-phased budget for the project. Show how much daily and...
using the data below create a time-phased budget for the project. Show how much daily and cumulative costs of a project is, just as monthly and cumulative costs are shown in figure 10. WBS Activity Intermediate Predecessor Duration in Weeks Resource Hourly cost Hours per week 1 Operational definition 1.1 Research literature 3 Becky $35 30 1.2 Identify and define terms 1.1 1 Ann $60 30 1.3 Obtain approval of definition 1.2 2 Clive $50 30 2 Target selection 2.1...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT