Pivot table, add new column for average

G

Guest

How can I add a new column to calculate average of other column in data field?
Thnks
Daniel
 
D

Dave Peterson

Show the pivottable wizard and drag that field to the pivottable data area.

Double click on that grey icon and choose Average.
 
D

Dave Peterson

Maybe add a new field to the row field area???

Or add a new field to the data field area, but move it up to where you want it.

(All done through the pivottable wizard)
 

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

Pivot table, average of nex column 1
pivot table of existing pivot table 1
pivot table, Average formula 3
Average of % in pivot table 1
Calculate a moving average 2
Pivot table Average with [h]:mm format 5
Formulas in Pivot Table 4
Pivot table average 1

Top