Excel 2010 Pivot Table - Show Value As

I have set up a pivot table. 2 of the fields are "Inseminations" and "Confirmed Pregnant" in the "values" area. They are the count of dates for inseminations and count of "1"'s as the "confirmed" indicator so we get:-

    Insemination    Confirmed

March 196 58

April 212 64

etc. What I am trying to get is the "Confirmed" number to display as a % of the "Insemination" i.e.:-

        Insemination    Confirmed

March 196 29.6%

April 212 30.2%

etc.

(This did not format as I typed it but hopefully the idea is there)

Tried all combinations of "Show Value As" I could muster but none gave correct answer. Thanks, Mike

Recent Questions...