How to calculate average daily sales for each month in a pivot table

1

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.

enter image description here

However, when Excel calculates these values in a pivot table, it gives me 28.

enter image description here

Why doesn't this give me the average I want? How can I make my pivot table do this?

rb195048

Posted 2015-03-19T14:33:31.450

Reputation: 23

No answers