In a pivot table, can the avg of a column include rows w/o data?
I have a pivot table set up that shows how many hours were spent on an
activity in a given month for various people. The source data does not show 0
if there were no hours, there is just no data. In my pivot table, when I
average a column, blank entries are not included in the average, even though
I have "For empty cells show 0"
Is there a way for the average of columns to count empty cells as 0 and
include them in the average?
|