Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / May 2008

Tip: Looking for answers? Try searching our database.

Calculated Field pivot Table Question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sfleck - 21 May 2008 18:52 GMT
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 - 22 May 2008 00:02 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.