Only using most recent data in Pivot table?

Hi there,

I am creating a spreadsheet for a network speed test that I complete hourly and I want to be able to create a dynamic pivot table that will only hold the last two days worth of entries.

I have so far created a dynamic pivot chart using a dynamic range, what I need is for it only to display the most recent entries. Is this possible?

So for example only display the last 10 entries in the chart.

Thanks in advance for your help!

I don't want to have to put the date on the table. Is there any way to sort it by the last day/week without having it there?
Thanks