Go to the Call Type by Rep worksheet. Tiana wants to compare the call data by type
Fantastic news! We've Found the answer you've been seeking!
Question:
Go to the Call Type by Rep worksheet. Tiana wants to compare the call data by type for each service rep. In cell A3, insert a PivotTable based on the Calls table. Use RepCalls as the name of the PivotTable. Display the service rep names as column headings, and the call types as both row headings and values.
Transcribed Image Text:
A. B D E F G H K M N P Pierce Software 1 2 Customer Call Log: January-March 3 Customer Survey Scores Que: Que: Que: Que: 4 Call Call Coc Call Ty Total Calls Average Score Dal 142021 Wagner Service Re n. 2 Averag 3.75 Rep Barry n n. n 20191 7 Feature request Bug report Tech problem Tech problem Cancellation Tech problem 4 4 #DIVIOI 142021 Thanh 142021 Darego 15/2021 Calder 15/2021 Shanahan 6 20154 1 2 1 1 1.75 Bruno 4.00 7 21170 17 5 5 5.00 Calder 2 3.63 8 21145 16 4 5 3 5 4.25 Darego 4.75 22103 21 4 4 4. 4 4.00 Shanahan 2 2.63 22246 22137 2.38 #DIVIO 10 P6/2021 Bruno 18 4 4 4.00 Thanh 2 11 17/2021 Thanh 7 Feature request Bug report Виg героrt Feature request 3 3 3 3.00 Volmann 12 22234 17/2021 Shanahan 1 2 1 1 1.25 Wagner 2 2.88 #DIVIO! 13 23228 17/2021 Wagner 2 3 2.00 Zimmerman 182021 Calder 192021 Darego 14 23215 8 4 3 3 2 3.00 15 24117 25 Cancellation 5 5. 3 4.50 16 24140 192021 Bruno 9 Feature request Bug report Bug report 3 3 3 2 2.75 17 25224 1112021 Thanh 3 4 4 4 4.25 23126 25210 112/2021 Volmann 112/2021 Barry V142021 Wagner 18 2 5 5 4 5 4.75 How to Cancellation 19 12 3 2 2 1 2.00 20 20189 21 1 1 1 1.00 21 20126 1142021 Shanahan 20 Tech problem Cancellation Tech problem Tech problem Bug report Tech problem Tech problem Tech problem Bug report Bug report How to 4 4. 2 3.25 22 26157 115/2021 Bruno 22 2 3 2 2 2.25 23 25201 118/2021 Thanh 16 4 3. 4 3.50 118/2021 Calder 116/2021 Calder 118/2021 Bruno 24 26149 19 4 5 5 4.75 25 23223 3 5 5 5 5.00 26 24241 17 4 3 3 3.00 27 24152 24196 117/2021 Thanh 18 5 4 4 4.50 28 117/2021 Volmann 16 4 3 5 3.75 29 26242 11712021 Darego 4 4 2 4 3.00 7. 30 27143 117/2021 Volmann 4 4 3 3 3 3.25 31 20155 1182021 Barry 15 3. 5 4.50 32 21171 1182021 Thanh Bug report Cancellation Tech problem 3 2 250 182021 Shanahan 1202021 Bruno 33 22227 22 2 2 1 1.50 34 20177 18 3 3 3. 3.00 35 27196 1202021 Zimmerman 15 How to 4 4 3. 4 3.75 Cancellation Tech problem Call Type by Rep 36 22213 1202021 Volmann 23 5 4 4 4.50 37 25200 1212021 Barry 16 4 4 4.50 Customer Call Log Scores by Date Survey Questions ... 国 A. B D E F G H K M N P Pierce Software 1 2 Customer Call Log: January-March 3 Customer Survey Scores Que: Que: Que: Que: 4 Call Call Coc Call Ty Total Calls Average Score Dal 142021 Wagner Service Re n. 2 Averag 3.75 Rep Barry n n. n 20191 7 Feature request Bug report Tech problem Tech problem Cancellation Tech problem 4 4 #DIVIOI 142021 Thanh 142021 Darego 15/2021 Calder 15/2021 Shanahan 6 20154 1 2 1 1 1.75 Bruno 4.00 7 21170 17 5 5 5.00 Calder 2 3.63 8 21145 16 4 5 3 5 4.25 Darego 4.75 22103 21 4 4 4. 4 4.00 Shanahan 2 2.63 22246 22137 2.38 #DIVIO 10 P6/2021 Bruno 18 4 4 4.00 Thanh 2 11 17/2021 Thanh 7 Feature request Bug report Виg героrt Feature request 3 3 3 3.00 Volmann 12 22234 17/2021 Shanahan 1 2 1 1 1.25 Wagner 2 2.88 #DIVIO! 13 23228 17/2021 Wagner 2 3 2.00 Zimmerman 182021 Calder 192021 Darego 14 23215 8 4 3 3 2 3.00 15 24117 25 Cancellation 5 5. 3 4.50 16 24140 192021 Bruno 9 Feature request Bug report Bug report 3 3 3 2 2.75 17 25224 1112021 Thanh 3 4 4 4 4.25 23126 25210 112/2021 Volmann 112/2021 Barry V142021 Wagner 18 2 5 5 4 5 4.75 How to Cancellation 19 12 3 2 2 1 2.00 20 20189 21 1 1 1 1.00 21 20126 1142021 Shanahan 20 Tech problem Cancellation Tech problem Tech problem Bug report Tech problem Tech problem Tech problem Bug report Bug report How to 4 4. 2 3.25 22 26157 115/2021 Bruno 22 2 3 2 2 2.25 23 25201 118/2021 Thanh 16 4 3. 4 3.50 118/2021 Calder 116/2021 Calder 118/2021 Bruno 24 26149 19 4 5 5 4.75 25 23223 3 5 5 5 5.00 26 24241 17 4 3 3 3.00 27 24152 24196 117/2021 Thanh 18 5 4 4 4.50 28 117/2021 Volmann 16 4 3 5 3.75 29 26242 11712021 Darego 4 4 2 4 3.00 7. 30 27143 117/2021 Volmann 4 4 3 3 3 3.25 31 20155 1182021 Barry 15 3. 5 4.50 32 21171 1182021 Thanh Bug report Cancellation Tech problem 3 2 250 182021 Shanahan 1202021 Bruno 33 22227 22 2 2 1 1.50 34 20177 18 3 3 3. 3.00 35 27196 1202021 Zimmerman 15 How to 4 4 3. 4 3.75 Cancellation Tech problem Call Type by Rep 36 22213 1202021 Volmann 23 5 4 4 4.50 37 25200 1212021 Barry 16 4 4 4.50 Customer Call Log Scores by Date Survey Questions ... 国
Expert Answer:
Related Book For
Operations and Supply Chain Management for the 21st Century
ISBN: 978-1111225292
1st edition
Authors: Ken Boyer, Rohit Verma
Posted Date:
Students also viewed these computer engineering questions
-
The following table display data from four experiments: a. Cell volume after 10 minutes in a watery bath b. Fish mass after 1 week in a chilly tank c. Gnat population size after 3 days without food...
-
The following table display data from four experiments: a. Cell volume after 10 minutes in a watery bath b. Fish mass after 1 week in a chilly tank c. Gnat population size after 3 days without food...
-
The following table display data from four experiments: a. Cell volume after 10 minutes in a watery bath b. Fish mass after 1 week in a chilly tank c. Gnat population size after 3 days without food...
-
Consider the many moments of joy in the movie. Why include them? What risky acts of courage do Katherine, Mary and Dorothy take? How are they rewarded? The film shows the strong relationships that...
-
Two Lizards is a specialty pet gift store selling exotic pet- related items through its website. Two Lizards has no physical store; all sales are through its website. Results for last year are shown...
-
Jones Inc. is preparing an aggregate production plan for next year. The company expects demand to be 1,000 units in quarter 1; 2,000 units in quarter 2; 4,000 units in quarter 3; and 3,000 units in...
-
The following note transactions occurred during the year for Towne Company: Nov. 25 Towne issued a 90 -day, nine percent note payable for \(\$ 8,000\) to Hyatt Company for merchandise. Dec. 7 Towne...
-
The accounts of Frequent Ad, an agency that develops marketing materials for print, radio, and television, follow. The agencys first year of operations just ended on January 31, 2014. Accounts...
-
Major investors in real estate include all except: a.Private investors b. Property and casualty companies. c. Life insurance companies. d.Pension funds.
-
The results below are based on data collected as part of a student project for an introductory statistics class at UF. If there is more than one group/treatment, the first group mentioned is group 1....
-
Multimodal Hub 1 is an industrial property in Pennsylvania with an in place 20 year-lease to a low credit company. The area is becoming a major warehouse hub. The tenant has 10 years left on the...
-
Assuming modified accelerated cost-recovery-system depreciation and an economic life of five years, what is the book value after three years of an asset of initial cost P?
-
A student loan of$25,000has a5%interest rate compounded daily. The following table includes repayment information for5-,10-, and15-year plans. If monthly payments of$200are made, how many years are...
-
What are the evolutionary consequences of symbiotic relationships, such as mutualism, commensalism, and parasitism, on the diversification and ecological success of interacting species, and how do...
-
The Victoria Fund, a child welfare fund, received $50,000 in cash in the current year. The donor requires the gift be held in perpetuity and that the income from investing this money may be used for...
-
3. Today is January 1, 2020, and you obtain the following quotes from the Wall Street Journal for several traded Treasury bonds with different maturities and coupon rates. Assume that coupons are...
-
6. . The post order traversal for the below given binary search tree, after deleting the nodes 6 and 13 is - 8 (10 (14) (13) Option A: 1,3,4,7,8,10,14 Option B: 1,4,7,3,8,10,14 Option C:...
-
The Heese Restaurant Group manufactures the bags of frozen French fries used at its franchised restaurants. Last week, Heeses purchased and used 101,000 pounds of potatoes at a price of $ 0.70 per...
-
Components R We (CRW) is a small job shop facility that does contract manufacturing of components for a large automobile company located nearby. The following table gives the setup time, processing...
-
Given the data in Table 5.22, compute the forecast error measurements indicated. 83 2. 4. 11 9 5 4 7 508 354 2 18 88599 541. 31 478 3 354 08 25 35 01 01 60 76 06 03 62 555 1 01 2 123456789
-
Product C is assembled from components D and E. Item D is made from item F and Item G. Item F is made from item J and item K. Item E is made from item H and item I. Item H is made from Item J. All...
-
Veering off the mission is one of the key challenges in the boardroom. Why is mission focus so essential to an organization?
-
How do you convince a new member to go through orientation if he has already served on numerous boards and feels he understands what board service is all about?
-
List specific examples of a board not meeting the duties of care, loyalty, and obedience.
Study smarter with the SolutionInn App