Including empty rows in pivot table

[Excel__N00B]

I am hoping this makes sense as I have been searching for hours and have found very little.

I am undertaking a survey which asks recipients a number of questions with multiple choice answers. The answers are recorded in a table. A pivot table is then used to calculate the percentages for each answer. I would like to have answers which have not had been selected by any of the recipients displayed as a row in the pivot table.

For example, the table looks like:

Q1 - Gender	Q2 - Were you happy with the service?
Male	Yes
Male	No

<tbody>
</tbody>

The pivot table for Q1 would then look like:

Row Labels	Count of Q1 - Gender
Male	100%
Grand Total	100%

<tbody>
</tbody>

I would like a row for Female as well which has the percentage as 0%. I aim to create pivot charts so would like the whole range of potential answers to be represented (even if they are 0%).

How do you I go about getting a row for Female?

 

[Rijnsent]

Hi N00B,
try the following:
-in your pivot table, right click the item and go for "Field Settings"->"Layout & Print" and make sure "Show items with no data" is switched on
-in your data, add lines for items that you want in your overview (so a line with "Female"), refresh the pivot
-delete the line and "Female should stay in the pivot even after refreshing
Hope that works,
Koen