jondavis1987
Active Member
- Joined
- Dec 31, 2015
- Messages
- 425
- Office Version
-
- 2019
- Platform
-
- Windows
I have a pivot chart and I have the filters set to Product Code, Location, Year, Month, and Date. So when I have product code selected to 3011-EST-1604, Location North Plant, Year 2016, Month November, The filter for Date still lists every single date that data has been entered for despite if it's the right product id or anything like that. Is there a way to make it where the drop down list for the date filter has already filtered everything else so it just has the dates selectable for that product code/month and all that