Pivot Table Dynamic offset

Job ID: 32535321

Budget: $15 – $25 CAD

I created excel data for golf scores.
I want
Average of last ten scores entered.
Continue adding more scores.
Continue Average of last ten scores.