Google sheet time comparison

Hi,

not sure if possible but is there a time comparison in google sheets. For example, in the Google data studio, it is very easy to make comparison between this week and last weeks data.

Is it possible to do the same in google sheets for example in pivot table?

I want to see amount spend between this and last week in pivot table.

Thanks,
Tim