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