Hi raisc12....
If you are open to a macro/VBA solution, I've had success using VBA combined with a simple data validation. My example is slightly different than yours in that I have 2 pivot tables with DIFFERENT data sources. The basic idea should work, though.
In the code below for the...