breakhappy
New Member
- Joined
- Jun 30, 2008
- Messages
- 22
Hello -
I am trying to customize the date filter function on a pivot table to show the last 90 days (or last 3 months would be even better). I attempted to put a formula, "=now()-90" into the date filter dialogue box, but excel won't allow it.
Is there a way to do this? I would ultimately like to be able to set the pivot table to update upon opening the file and the date filter would show only records for the past 3 months because it's connected to a pivot chart. I cannot alter the source in anyway and only have control over the pivot table and chart.
Any ideas?
- Jess
I am trying to customize the date filter function on a pivot table to show the last 90 days (or last 3 months would be even better). I attempted to put a formula, "=now()-90" into the date filter dialogue box, but excel won't allow it.
Is there a way to do this? I would ultimately like to be able to set the pivot table to update upon opening the file and the date filter would show only records for the past 3 months because it's connected to a pivot chart. I cannot alter the source in anyway and only have control over the pivot table and chart.
Any ideas?
- Jess