ErockMahan
New Member
- Joined
- Feb 11, 2020
- Messages
- 2
- Office Version
- 365
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
I have a pivot table that is reading thousands of records.
The pivot has three filters, one of which is the amount of time since yada yada yada.
I want it only to show things within the past 5 days, but I don't want to manually click through the filter for a thousand different possibilities.
I feel like there should be an easy way to do this, it's just beyond me at this point! (And if there isn't, a macro wouldn't hurt, either)
The pivot has three filters, one of which is the amount of time since yada yada yada.
I want it only to show things within the past 5 days, but I don't want to manually click through the filter for a thousand different possibilities.
I feel like there should be an easy way to do this, it's just beyond me at this point! (And if there isn't, a macro wouldn't hurt, either)