I have a pivot table below that I am trying to filter dynamically based on a separate list and am trying to figure out how to do this by referencing the relevant field. In the below example I have the same data set and I would like to filter column B (referral) by G3:G4 (12.com and ab.com). Ideally, the final result would be the pivot table would display everything aside from "xyz.com" found under
In the pivot table editor I've tried to choose filter -> referral -> filter by condition by a few different ways including:
If I run the above formulas outside the pivot table's filter it works fine, but inside nothing seems to work, even replacing B3 with B:B
If anyone has any advice on how to get this to work I would be highly appreciative.