I need to calculate the averages I have in a month. What I'm expecting is to calculate 936, 184, 943, and 230 and get an average of 573. (see screenshot 1) https://www.dropbox.com/s/35d4jmffkg...t%201.png?dl=0

However, when Excel calculates these values in a PivotTable, it gives me 28. (see screenshot 2) https://www.dropbox.com/s/p9jk4j77g8...t%202.png?dl=0