| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table, Average formula
I can add another column in pivot table but don't know how to
write formula to calculate the average of the next coluumn. I use excel average function but not work EVERAGE($L:$L) It give me an error, not pivot tabel formula?? Any ideas are welcome. Daniel |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table, Average formula
Hi Daniel
Right click on PTLayoutdrag field to the data area (a second time if necessary)double-click on field nameAverage -- Regards Roger Govier "Daniel" wrote in message ... I can add another column in pivot table but don't know how to write formula to calculate the average of the next coluumn. I use excel average function but not work EVERAGE($L:$L) It give me an error, not pivot tabel formula?? Any ideas are welcome. Daniel |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table, Average formula
And if Roger's suggestion doesn't accomplish what you want, perhaps you
can create formulas outside of the pivot table, to calculate the average of a pivot table column. Daniel wrote: I can add another column in pivot table but don't know how to write formula to calculate the average of the next coluumn. I use excel average function but not work EVERAGE($L:$L) It give me an error, not pivot tabel formula?? Any ideas are welcome. Daniel -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table, Average formula
Thanks for response
The idea is creating a dynamic chart because of changes in future. In this chart I have a line of average and want to refresh data in excel and pivot table. Dynamic chart will be auto redrawn. I have many charts so can not manually draw one by one. Daniel "Debra Dalgleish" wrote: And if Roger's suggestion doesn't accomplish what you want, perhaps you can create formulas outside of the pivot table, to calculate the average of a pivot table column. Daniel wrote: I can add another column in pivot table but don't know how to write formula to calculate the average of the next coluumn. I use excel average function but not work EVERAGE($L:$L) It give me an error, not pivot tabel formula?? Any ideas are welcome. Daniel -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table, add new column for average | Excel Discussion (Misc queries) | |||
| Calculated field in pivot table, simple Average formula | Excel Discussion (Misc queries) | |||
| Weighted Average in Pivot table | Excel Worksheet Functions | |||
| How do I use a pivot table to get an average count? | Excel Discussion (Misc queries) | |||
| How to Get Sum of the Average in Pivot Table? | Excel Discussion (Misc queries) | |||
Linear Mode
