Calculated Fields in Pivot Tables
 

I have just used the Calculated Field function in a Pivot Table in
order to give me the value of one field divided by another field.
Although I have the new Calculated Field in my Pivot Table it assumes
that I want the Sum of this field, but I actually want the Average
instead...

How can I get averages instead of sums?

Calculated Fields in Pivot Tables
 

"How can I get averages instead of sums?"
..you should be able to right-click the number and select average
instead of sum


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=529127

Calculated Fields in Pivot Tables
 

Thanks steven1001, but it won't let me do that with a calculated
field...

Calculated Fields in Pivot Tables
 

You can't change the summary function for a calculated field. Perhaps
you can do the calculation in the source data, and add that field to the
pivot table.

Pelham wrote:
I have just used the Calculated Field function in a Pivot Table in
order to give me the value of one field divided by another field.
Although I have the new Calculated Field in my Pivot Table it assumes
that I want the Sum of this field, but I actually want the Average
instead...

How can I get averages instead of sums?



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

Calculated Fields in Pivot Tables
 

Debra

Yes, that is what I actually resorted to doing as the next best
option... Thank you anyway - again!

By the way, I love your website and it is one of my three main Excel
sources. As a result I am keen to get a copy of the table of contents
(TOC) of your Pivot Tables book before I decide to buy it... Can you
send me a copy of the TOC to my e-mail address that I used to e-mail
you last week?

Regards
Pelham

Calculated Fields in Pivot Tables
 

Thanks! You can download a copy from the publisher's site:

http://www.apress.com/book/supplemen...10088&sID=3340

Pelham wrote:
Debra

Yes, that is what I actually resorted to doing as the next best
option... Thank you anyway - again!

By the way, I love your website and it is one of my three main Excel
sources. As a result I am keen to get a copy of the table of contents
(TOC) of your Pivot Tables book before I decide to buy it... Can you
send me a copy of the TOC to my e-mail address that I used to e-mail
you last week?

Regards
Pelham



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