Forum Discussion
Stinky111
Jan 03, 2022Copper Contributor
Pivot filter
Hello, I am wondering if it is possible to create a pivot table, but have it filter based off a table, or list, that will be filled in on a set-up sheet. For instance, we have the pivots, and the raw...
SergeiBaklan
Jan 03, 2022Diamond Contributor
PivotTable ignores source data filtering. The workaround could be to create intermediate dynamic source and build PivotTable on it. Technique is described here Pivot Table from Filtered List Visible Rows – Contextures Blog