| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table, add new column for average
How can I add a new column to calculate average of other column in data field?
Thnks Daniel |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table, add new column for average
Show the pivottable wizard and drag that field to the pivottable data area.
Double click on that grey icon and choose Average. Daniel wrote: How can I add a new column to calculate average of other column in data field? Thnks Daniel -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table, add new column for average
I meant add more columns after the first column. Thnks. Daniel
"Dave Peterson" wrote: Show the pivottable wizard and drag that field to the pivottable data area. Double click on that grey icon and choose Average. Daniel wrote: How can I add a new column to calculate average of other column in data field? Thnks Daniel -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table, add new column for average
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) Daniel wrote: I meant add more columns after the first column. Thnks. Daniel "Dave Peterson" wrote: Show the pivottable wizard and drag that field to the pivottable data area. Double click on that grey icon and choose Average. Daniel wrote: How can I add a new column to calculate average of other column in data field? Thnks Daniel -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weighted average on a pivot table | Excel Discussion (Misc queries) | |||
| weighted average in pivot table | Excel Discussion (Misc queries) | |||
| adding average to pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table -- Add column to average Grand Total | Excel Worksheet Functions | |||
| How to Get Sum of the Average in Pivot Table? | Excel Discussion (Misc queries) | |||
Linear Mode
