Analysing large amounts of data in excel using pivot table, not working correctly

Hello,

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 would be very grateful if anyone could help me

This has also been posted on other forums
https://www.excelguru.ca/forums/show...-a-pivot-table
Also MrExcel but the website has seemed to of crashed, but will upload the link when it re-loads

Megan