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

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

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

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