Pivot table > date filters. Any way to set to most recent days?

[eggman2001]

Hello,

I have a pivot table that's based on data that has a column for dates.
If I want to filter the dates, so that I get the most recent 14 days,
I can set this using "between" but then I'd have to adjust that every
day that I look at the data. Is there a way to set this dynamically so
that it always shows the most recent 14 days?

 

[eggman2001]

Furthermore, I'd like to create a pivot table field (or something that
will do this automatically) that calculates the average for a
particular column over my date range (recent 14 days). Is this doable?