Pivot Table Dynamic offset

Job ID: 32535296

Budget: $10 – $30 USD

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.