Unable to change field settings in calculated field in a pivot tab

G

Guest

I have a pivot table that uses a calculated field in the data items section.
This is just a simple calculated field that divides one column by the other
from the data list.

The calculated field works fine, except that I need the data averaged and
not summed as it is defaulting to. In the field settings for the calculated
field, the ability to change the "summarized by" block is greyed out and I
can't change it to average.

I know of a work around to this by just adding another column to my data
list but I would rather not do it that way.

Is it possible to change the "summarized by" setting for a calculated field?

Thanks in advance for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculated field in Pivot Table 2
Delete calculated field 1
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Mystery field in pivot table 8
calculated fields - change field settings 6
Calculates field in pivot table 2
Pivot Table Calculated field error 1
Pivot Table Calculated Field - Sum/count 1

Top