A calculated field will always use the Sum of the selected fields, even
if you have used a different function in the pivot table, such as Count.
As a workaround, you could add a column to the source data table, with a
heading of SchoolsCount. Enter a 1 in each row for the SchoolsCount.
Then, refresh the pivot table, and add the SchoolsCount field to the
data area, as Sum.
Use the SchoolsCount field in the calculated field, instead of the
Schools field.
> I have a pivot table that I would like to have a calculated field that fids
> the avereage by evaluating the the count of schools / total sales.
[quoted text clipped - 4 lines]
> I have used Count but it always returns 1 as I have discovered by looking at
> this board is the result you will always get.

Signature
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
sfleck - 22 May 2008 00:26 GMT
Thank You I saw your Suggestion in Another string.
I actually think that I have solved it with another work around using
GetPivotData
It is not a part of the table but reflects the results I am looking for
Thank you for your time in assisting me
> A calculated field will always use the Sum of the selected fields, even
> if you have used a different function in the pivot table, such as Count.
[quoted text clipped - 14 lines]
> > I have used Count but it always returns 1 as I have discovered by looking at
> > this board is the result you will always get.