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 th...
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.