Calculate daily averages in a pivot table with weekly or other irregular periodic data

Charles Bushby

New Member
Joined
Aug 10, 2005
Messages
42
If I have this data in a list how do I calculate the average daily sales using weekly totals. The pivot table would give a result of 5.35 for January but I reckon it should be 4.42. Furthermore if the sales data were not weekly but irregular how would I then calculate the average daily sales?

Any help with this would be most appreciated.

Charles Bushby

DateSales per week
29-Dec-19​
40​
05-Jan-20​
50​
12-Jan-20​
30​
19-Jan-20​
20​
26-Jan-20​
50​
02-Feb-20​
2​
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Charles Bushby

New Member
Joined
Aug 10, 2005
Messages
42
I should add that I am trying to show the data by grouping monthly in a pivot table to show daily sales per month
 

Watch MrExcel Video

Forum statistics

Threads
1,118,714
Messages
5,573,772
Members
412,550
Latest member
soking
Top