Hi,
I'm trying to recreate a table using a pivot table but am struggling with one final element. The normal table shows the number of reports written by analyst per month for each year, with a total and average for the year.
2012
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Average
Analyst1 0 0 7 3 3 3 4 4 4 6 5 0 39 4
Analyst2 13 21 32 17 19 14 21 19 22 33 23 0 234 20
Analyst3 9 18 21 12 15 12 16 17 18 23 22 0 183 15
Analyst4 6 12 16 8 13 8 12 13 14 19 13 0 134 11
Total 28 51 76 40 50 37 53 53 58 81 63 0 590 12
I have recreated this whole table successfully apart from the last column - the average for the year. In the normal table it is an average formula of the Jan-Dec values but I can't work out how to do this in the pivot table - any pointers?
Thanks,
Emmy
I'm trying to recreate a table using a pivot table but am struggling with one final element. The normal table shows the number of reports written by analyst per month for each year, with a total and average for the year.
2012
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Average
Analyst1 0 0 7 3 3 3 4 4 4 6 5 0 39 4
Analyst2 13 21 32 17 19 14 21 19 22 33 23 0 234 20
Analyst3 9 18 21 12 15 12 16 17 18 23 22 0 183 15
Analyst4 6 12 16 8 13 8 12 13 14 19 13 0 134 11
Total 28 51 76 40 50 37 53 53 58 81 63 0 590 12
I have recreated this whole table successfully apart from the last column - the average for the year. In the normal table it is an average formula of the Jan-Dec values but I can't work out how to do this in the pivot table - any pointers?
Thanks,
Emmy