Filter a Pivot Table on another tab

Occasional Contributor

Good morning!  I currently have this giant pivot table that is being sliced properly.  I was wondering, if I could also filter it based on another tab.


I have the tab "NPD" which has the dates that I need to filter on (if the location and shop have a yellow x, I need to show that date).  Is it possible to connect those dates with the pivot table?


ex) for TMMI East Assembly, I need to show 4/1, 4/14,4/15,4/18, ect (I don't need to show every other date)

0 Replies