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 180Unsuccessful 150 90 20 60N/A 2 2 2 6No 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 TotalUnsuccessful 1 1 155 157Successful 42 42Unsuccessful 1 1 113 115Grand 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

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.

back

Follow this topic

matthew james

Last answered:

January 28, 2020

Posted on:

January 15, 2020

Help please with Pivot Table?

2 answers ( 0 marked as helpful)

Ned Krastev

Posted on:

January 17, 2020

Tamilarasan

Posted on:

January 28, 2020

Submit an answer

Content