pivot table, Average formula

G

Guest

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
 
R

Roger Govier

Hi Daniel

Right click on PT>Layout>drag field to the data area (a second time if
necessary)>double-click on field name>Average
 
D

Debra Dalgleish

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.
 
G

Guest

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
 

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

Pivot table, average of nex column 1
Pivot Table Average Problem 2
Formulas in Pivot Table 4
Average of Subtotals in Pivot Table 0
Pivot table Average with [h]:mm format 5
Pivot table average 1
pivot table of existing pivot table 1
Pivot Tables - calculate field? 2

Top