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.

FaN404 wrote:
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" wrote:


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

FaN404 wrote:

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?


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





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