Pivot table, average of nex column

G

Guest

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
 
D

Debra Dalgleish

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
 

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, add new column for average 3
pivot table of existing pivot table 1
pivot table, Average formula 3
Average of Subtotals in Pivot Table 0
Average of % in pivot table 1
Insert a text in column A and calculoate the average for every gro 4
Pivot Table Calculation 4
Pivot Table Average Problem 2

Top