Pivot table, average of nex column
 

how can I create a column so it can calculate average on the next column.
In my table below. I did create a average column, but how can I add a formula
to calculate the sale column. In this case I wish the average column should
show 23600 all rows. Thnks for your help. Daniel

My pivot table like this

name sale average
smith 20000
john 13000
daniel 30000
roger 40000
dany 15000

Pivot table, average of nex column
 

You could add a couple of columns to the source data to calculate the
average, then add that new field to the pivot table.
For example, with amounts in column I, and employee names in column G,
add this formula to column L, to calculate the employee totals:

=IF(COUNTIF($G$1:G2,G2)=1,SUMIF(G:G,G2,I:I),"")

In another column, use this formula to calculate the the average total:
=AVERAGE(L:L)

Add the AvgTotal field to the pivot table, as Max of AvgTotal

Daniel wrote:
how can I create a column so it can calculate average on the next column.
In my table below. I did create a average column, but how can I add a formula
to calculate the sale column. In this case I wish the average column should
show 23600 all rows. Thnks for your help. Daniel

My pivot table like this

name sale average
smith 20000
john 13000
daniel 30000
roger 40000
dany 15000


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html