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 ... 国

Answer rating: 100% (QA)

Solution Step 1 Select the table from A... View the full answer