pivot table, Average formula

D

Daniel

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

Daniel

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

Dealing with a Pivot Table (when I don't want to) 0
Formulas in Pivot Table 4
Pivot Table Calculations 0
Average of % in pivot table 1
Pivot table Average with [h]:mm format 5
Average of count of column in Pivot 0
Pivot table, average of nex column 1
Formula within Pivot Table Calculated Field - Days in time period 0

Top