Hi all... first time poster here. Hoping someone can show me the light.
I have a spreadsheet that contains survey scores and date of scores for individuals. I'm using a pivot table to display scores for individuals by month.
person Jan Feb Mar Apr GrandTotal
John 80% 70% 80% 75% 76.25%
The problem is that the Grand Total Average (calculated by the pivot table) does not return the actual average.
Anyone have any idea why?
Bookmarks