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