BloodyBill
New Member
- Joined
- Oct 5, 2020
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
I have a pivot table where rows of data are sorted by date (left column). I want to filter the data rows by date.
What I want to do is have the pivot table only show me data from today through the rest of the next 2 weeks (no matter how many days of data exist). So, if today is Tuesday, I want Tuesday (1/17) through the following Monday (1/30). I want the pivot table not to show me any lines of data from earlier than today, nor data beyond 1/30.
I see pivot table date filters for today, tomorrow, next week, next month, next quarter, etc. Also between, before and after two dates.
I don't want to reset the date filter every time I import another day's data. I want it to show "Today + 13 days", no matter what day today is.
Can I set up date filters in this way?
What I want to do is have the pivot table only show me data from today through the rest of the next 2 weeks (no matter how many days of data exist). So, if today is Tuesday, I want Tuesday (1/17) through the following Monday (1/30). I want the pivot table not to show me any lines of data from earlier than today, nor data beyond 1/30.
I see pivot table date filters for today, tomorrow, next week, next month, next quarter, etc. Also between, before and after two dates.
I don't want to reset the date filter every time I import another day's data. I want it to show "Today + 13 days", no matter what day today is.
Can I set up date filters in this way?