When you've got the dynamic table created, press the right button over the
button which says something like "Count of...". Select "Field Config .." (I'm
translating into english because my version is spanish), then select
"Average" instead of Count.

"attaboy" wrote:

Thanks, I tried this but am getting a different result.
Bob - 0%
William - 100%

Am i missing something?

"Eddie Holder" wrote:

Add your fields in the pivot table data as follows

Row = NAme
Data = passrate
Double click on the data elelement and choose the Options button
From the dropdwon below the options, choose Show data as % of column
Choose OK and complete the pivot table

Hope this helps

--


Alwyas Trying
Eddie


"attaboy" wrote:

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