Results 1 to 5 of 5

Thread: Analysing alot of data using a pivot table

  1. #1

    Analysing alot of data using a pivot table

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I am trying to create a pivot table from data that I have collected from a group questionnaire, there is 40 questions. Each question has about 5 different answer options. Every time I go to create the table it adds all the answers up to give me a total of people that answer. I already have this information. I have changed the values to count but it still adds the total which is not what I want. I want to see each individual answer!

    I have attached a brief copy of what I am trying to achieve and to see if you can understand. forum upload.xlsx

    I would be very grateful if anyone could help me


  2. #2

    Unfortunately the MrExcel has crashed therefore I cannot access the link to this question at this time.
    moderator edit: it is

    I would also like to apologise for posting on multiple forums but I needed an answer asap!
    Last edited by p45cal; 2017-08-05 at 10:06 PM.

  3. #3
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Don't put anything in the value pane.

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Excel Version
    Quote Originally Posted by MEGANED5 View Post
    I want to see each individual answer!
    This of course is exactly what pivots are NOT about. They're about summarising data.

    Is this the sort of thing you're looking for?:
    Click image for larger version. 

Name:	Capture3.JPG 
Views:	29 
Size:	47.7 KB 
ID:	7157
    Click image for larger version. 

Name:	Capture4.JPG 
Views:	27 
Size:	53.0 KB 
ID:	7159
    See Sheet2 in attached.
    Attached Files Attached Files
    Last edited by p45cal; 2017-08-06 at 02:33 PM.

  5. #5
    Thank you!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts