Forum Discussion
Filter a Pivot Table on another tab
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)
1 Reply
If your current pivot is based off the data model, you could add the data from that other tab as a filter to the existing pivot table. Then you can create a relationship between both tables and filter on the respective field. Does that make sense? See https://support.microsoft.com/en-us/office/work-with-relationships-in-pivottables-f64ea03b-435a-448d-bc35-3b252bd1233a for some starter information.
