I have a pivot table with week #'s as column headers. As the year goes on columns are added 1,2,3,4...52 etc. I would like the pivot table to calculate the average of the previous 6 weeks. Any help would be awesome, this is very important.