The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Help please with Pivot Table?

Help please with Pivot Table?

0
Votes
2
Answer

Happy New year everyone & all the best for 2020!
Please can you help sort the data/ pivot Table out. 
 
I am trying to establish a across 3 contact attempts how many times a call is Successful, Unsuccessful or no attempt was made to look  like the Below:
                          Contact attempt 1 Contact attempt 2 Contact attempt 3 Grand Total
Successful         100                             60                         20                     180
Unsuccessful   150                              90                       20                        60
N/A                      2                                 2                         2                          6
No Attempt         50                               50                      50                        150
 
But the Outcomes and the Column headers get mixed up and under the incorrect headings. 
Count of Unique Reference Column Labels
Row Labels                                    No Attempt Successful Unsuccessful Grand Total
Unsuccessful                                      1                    1                155                 157
Successful                                                                42                                      42
Unsuccessful                                           1                 1               113                115
Grand Total                                         1                    1                 155                157
 
As you can see the outcomes are in the rows and Columns and column headers do not  show up at all.
 
any chance you can assist to point out where i am going wrong?
 
Thanks
Matt

2 Answers

365 Team
0
Votes

Hi Matthew,
Thanks for reaching out!
It is a bit difficult for me to indicate without seeing the file. One potential reason is that you are ”counting” and not ”summing”.
You should be able to change from count to sum in the bottom corner of the pivot pane.
Could you try that, please?
Thanks!

Totally agree was difficult enough trying to type it in the Q&A, is there any way i can send you the file? I attempted to change to Sum and is not working either. Thanks Matt

6 months

0
Votes

can you share your file to my Email id, lets try to find a solution together. 

×
Learn Data Science
this Summer!
Get 50% OFF