calculated fields - change field settings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!
on a calculated field I've just created, the SUM settings appears by default.
As I wish to calculate AVERAGE, how can I change from SUM to AVERAGE?
From the context menu of my calculated field column I select FIEL SETTINGS,
and a small dialog box opens with several options: SUM, COUNT, AVERAGE, etc.

But I can't change/choose none.

Is there a way to change from SUM to AVERAGE?

Thanks.
FN
 
Tue, 10 Jul 2007 23:18:04 -0700 from FaN404 <FaN404
@discussions.microsoft.com>:
on a calculated field I've just created, the SUM settings appears by default.
As I wish to calculate AVERAGE, how can I change from SUM to AVERAGE?
Click to expand...

Click in the cell, press F2, and type the change.

Maybe I misunderstood your question?
 
FaN

Are you talking about hitting the AutoSum icon?

There should be a drop-down arrow at rightside of the Icon.

Click on that to get more options.


Gord Dibben MS Excel MVP
 
You can't change the summary function for a calculated field in a pivot
table. Sum is the only function available.
 
Hi Debra,

Thanks for your answer!

Is there any way to change this setting from SUM to AVERAGE?

It seems to me to be a limitation on the scope of calculated fields.


Cheers,
FN
-----------------------------------------------------------
 
You're welcome. There's no way to change the setting. Depending on what
the calculated field does, perhaps you could add a field in the source
data that does a similar calculation, then add that to the pivot table,
and show the average.
 
Hi Debra,

That seems to be the best alternative.

Thank you and to everybody on this forum for your contributions.

FN
---------------------
 
Back
Top