soderlloyd
New Member
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
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