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

  • Thread starter Thread starter eggman2001
  • Start date Start date
E

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?
 
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?
 
Back
Top