Rolling averages

[BlackYellow]

Hello, i have a rather complicated issue that I am trying to resolve.

I have over 200,000 lines of raw sales data in excel.

The data looks something like this:
Customer Id / Invoice # / Date / Inventory / Quantity / Value
1001 / inv1 / 1-1-18 / cheese / 10 / 45.50
1001 / inv1 / 1-1-18 / sauce / 2 / 15.00
1002 / inv2 / 1-1-18 / cheese / 6 / 30.00

I know how to display this data in a pivot table but how do i calculate the rolling average over a 7 day period of sales for each customer?

 

[mrbeanyuk]

Would this work?

https://www.deskbright.com/excel/rolling-average-in-excel/

 

[bigmyk2k]

If there are multiple sales to a single customer in a given day, you could use the manual version of the above answer, and do a AVERAGEIFS with TODAY() and TODAY()-7, then copy that down.