How to add average column to pivot table??

[krusha]

Hi guys,
I am having trouble with what seems pretty simple. I would like to add 2 columns to the right of my pivottable as shown in the uploaded file here:

http://foxweb.marist.edu/users/kcdhl/pivotquestion.xls

, one that will be an average of the last 5 days volume, and one that will be the average volume for the past 100 days. I cannot figure out how to properly add the extra fields, any help would be GREATLY appreciated.

Thanks all.

 

[Ketan]

I understood the last "five days" are w.r.t. current date.

I would like to suggest following steps :

1)In cell A2, put fomula : =today()
2)In cell B2 put formula : =$A$2-B4 where B4 having the date from pivot table. Copy the formula till CM2
3)For last 5 days average for person A, put the formula in CO5 : =SUMIF($B$2:$CM$2,"<6",B5:CM5)/5(for last five days)
4)drage the formula for preson B and C

Check the data and share your experience