Pivot Table Dynamic offset -- 2

Job ID: 32535808

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.