Calculated Field with Formula in Pivot Table in Excel

[NNOG28]

Hi all Excel Experts,

I would like to create a calculated field in Pivot Table by using formula to calculate the average of the latest 3 weeks sales/ Retail Price. I do not want to manual change the formula each week to calculate the latest 3 weeks I update weekly

Could you please advise how to do it? TIA

Ie. below is the example of Pivot table data

Item	Sum of WK1 Sales	Sum of WK2 sales	WK3 sales	Avg. L3W Sales (calculated filed in pivot table)
A	500	400	450	483
B	100	100	100	100
C	300	600	900	600

 

[cyrilbrd]

Hi, it might be easier to just extract the averaged sales with formulae outside of a Pivot Table.
Given in A1:

with

=AVERAGEIFS($C$2:$C$13,$B$2:$B$13,">="&TODAY()-21,$A$2:$A$13,F2)