Help with averaging in pivot

[soderlloyd]

Hi -

I am trying to get the average of calls on each day of the week and I have data for 3-4 consecutive Mondays, Tuesday, etc. So, for example, on Sunday I have 4 Sundays of calls (11, 9, 8, and 12). I need the average of that which is 10, but I need it to be in a pivot table because I will need to break it down by other variables such as Team and E/A.

I have attached the data in case that is helpful.

Thank you so much!

-Laurel

 

[Anbuselvam K]

Is the below image results are okay? check the attached file.

 

[soderlloyd]

This is great! Thank you!