Rolling Date From Pivote Table

[Srushbri]

Hi,

I am forecasting for a call center. I have a list of calls with all their details (date, start/end time and date, queue, etc.). I am using pivot tables to group them into days, months, intervals and so on. I am hoping to be able to get a rolling weekly average based on N weeks to display. how could I do this? I think using a pivot table might be best but I am open to any suggestions.

Thanks,
Sofia

 

[CsJHUN]

If you have days in pivot column you can group them by weeks(7day) and set the values to avg not sum

Dropbox link to sample file