Pivot table, add new column for average

D

Daniel

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

Cell data entering slow! 0
Pivot table, average of nex column 1
Pivot table put multiple "Values" in one row but I want them in one column. 0
pivot table of existing pivot table 1
Excel Issue with "Average" showing in Status Bar 2
Dealing with a Pivot Table (when I don't want to) 0
Average of count of column in Pivot 0
Using Subtotals tool to average multiple rows of non-continuous data based on ID # 0

Top