1
I have 15 colleagues who have answered 'numerous questions' over the years in a questionnaire. The questions used to be standardised and all colleagues had the same questions. Unfortunately standards slipped and people didn't notice that different terminology was being used in some questionnaires.
I now need to standardise the questionnaire again, but basing my list on the most used terminology. Majority rules. i.e. Do you have a Pet? rather than, do you have an animal in the house?
I've put the data in to relevant columns, but now I need to be able to see which questions appeared the most in the questionnaires.
My PT shows me what has been answered and how many times, but what would help would be a sub-total showing me it's % of the total.
I could just write a formula manually next to the PT but I thought the PT would include something that wouold allow extra manipulation of the data, but I'm struggling to find the missing link...
Updated question - I updated the question because I realised that it didn't really explain my dilemma very well.
Many thanks
Michael.
Cheap and cheerful example below:
---Question 1--------Chosen
---Colleague 1-------1
---Colleague 2-------1
---Colleague 3-------1
---Colleague 3-------1
-----Sub-Total-------4
-------------% Sub-total----26% ((4/15)*100)---
Thanks Daljit. Your reply helped me realise that i hadn't explained myself very well. The example spreadsheet is great, but it is looking at a different type of problem - hence my hopefully better explination of the dilemma. – RocketGoal – 2010-07-05T15:35:26.953
Nope, I think the problem is something that a Pivot Table can't answer itself, but that we need to use helper columns to use within the Pivot Table. Not easy when the data is like mine but possible I suppose. Your answer led me to a better understanding of my problem. Thanks. – RocketGoal – 2010-07-12T15:08:25.767