I'm trying to calculate the monthly average of a set of data in a pivot table. I understand the average is being calculated using the number of lines in the data as the divisor, is there a way to calculate the average using the number of days in a month instead? Sample data sheet attached.
Bookmarks