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.

the count of shools is created when placed in the data but my question is it
possible to then use that data in a formula that is dynamic?

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.

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.


sfleck wrote:
> 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.
>
> the count of shools is created when placed in the data but my question is it
> possible to then use that data in a formula that is dynamic?
>
> 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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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

"Debra Dalgleish" wrote:

> 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.
>
>
> sfleck wrote:
> > 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.
> >
> > the count of shools is created when placed in the data but my question is it
> > possible to then use that data in a formula that is dynamic?
> >
> > 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.
>
>
> --
> Debra Dalgleish
> Contextures
> http://www.contextures.com/tiptech.html
>
>