# Excel Pivot: How can I show the % of the sub-total against the Grand total?

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)---

-