G Guest Jul 5, 2007 #1 How can I add a new column to calculate average of other column in data field? Thnks Daniel
D Dave Peterson Jul 5, 2007 #2 Show the pivottable wizard and drag that field to the pivottable data area. Double click on that grey icon and choose Average.
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 Jul 6, 2007 #4 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)
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)
