I am trying to create a formula within a pivot; an example of the data is as
below:

Name Value
William 0
Bob 0
William 1
William 1
Bob 0
(0 & 1 are used for Pass & Fail from some other test)
I need to calculate Pass percentage for the two guys. The expected result
would be:
William = 2/3=66.66%
Bob = 0/2 = 0%

I realise that this can be done using sum & count independently in the pivot
data and externally calculating the percentage, but is messy for a large data
range.

Is there a way of doing this using formulas within the pivot.

Thanks