Calculated field in pivot table does not summerize for average

D

Dev

My calculated field in a pivot table does not summarize by average. Excel
allows me to change field setting to average, and the title changes to
“Average of filed1â€, but actual calculated value is still the sum not the
average. Is this a bug in Excel?

Dev
 
J

Jen Perlee

I'm having the same issue...did you ever find an answer? It is driving me
crazy.

Anyone out there have an answer?

Thanks
Jen
 

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

Formula within Pivot Table Calculated Field - Days in time period 0
Doughnut Chart linked with the slicer in the pivot table 0
Setting column width in a table with a macro is not working 0
Excel does not accept text format! 0
I can't add a calculated item to a pivot table 0
Slicers and Calculated Items in Pivot Table 2
Pivot table put multiple "Values" in one row but I want them in one column. 0
Pivot Table calculated field error 2

Top