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)