calculated fields - change field settings

[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

 

[Stan Brown]

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 in the cell, press F2, and type the change.

Maybe I misunderstood your question?

 

[Gord Dibben]

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

 

[Debra Dalgleish]

You can't change the summary function for a calculated field in a pivot
table. Sum is the only function available.

 

[Guest]

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
-----------------------------------------------------------

 

[Debra Dalgleish]

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.

 

[Guest]

Hi Debra,

That seems to be the best alternative.

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

FN
---------------------