Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Convert the two below Proper Data Sets to Excel Tables and name the tables smartly, names like Revenue Table and Sales RepLookupTable. Using the Relationship
Convert the two below Proper Data Sets to Excel Tables and name the tables smartly, names like Revenue Table and Sales RepLookupTable. Using the Relationship feature in the Data Ribbon Tab, create a relationship between the two columns using the Sales Rep Column. Then make a Cross Tabulated PivotTable Report that counts How Many Sales there were for each Product in each Region. Put the PivotTable on a New Sheet. Revenue Customer Amazon.com 7448 4908 4427 4344 Date Sales Rep 10/7/2018 Luke 10/26/2017 Jeri 5/20/2018 Sheliadawn 9/24/2017 Jon 1/14/2018 Steven 4/3/2017 Sheliadawn 1/20/2018 Jeri 2/26/2017 Jeri 12/16/2018 Jeri 4/5/2017 Jeri 6/24/2018 Jeri 8/22/2017 Chin 11/9/2018 Luke Costco Home Depot Whole Foods McLendon's Hardware Whole Foods Nature Company Home Depot Amazon.com Costco Yahoo Sherman Williams Google Product ILP Item XOU Item JHF Item XOU Item MEB Item AIM Item MFB Item ILP Item XOU Item XOU Item MFB Item LXS Item 5826 5231 4234 6687 4857 7715 1702 8739 2639 AIM Item Please be sure to have a proper Data set. A proper Data set contain: i)Column Headers / Field Names in First Row, ii) Each row contains a record or transaction, iii)Leave empty cells or Excel column/row headers around the entire Proper Data Set Sales Rep Luke Jeri Sheliadawn Jon Steven Chin Rhonda Troung Start Date Pension Plan 4/22/2011 TIAA-CREF 3/16/2003 Hawthorne 9/13/2011 TIAA-CREF 9/20/2003 Hawthorne 9/11/2016 TIAA-CREF 12/8/2008 TIAA-CREF 7/26/2015 Hawthorne 4/24/2000 TIAA-CREF Region South East West North MidWest North East West North MidWest Das
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started