Help please with Pivot Table?
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
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 ( 0 marked as helpful)
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!
can you share your file to my Email id, lets try to find a solution together.