Well I tried to make my title descriptive, but the problem is hard for me to explain. I found some very cool code that selects values in a "secondary" pivot Cache Slicer (Excel 2010) which are selected in the "main" pivot Cache Slicer. (These are different caches, the slicers do not seem to want to work across multiple caches)
It looks like this:
Please Login or Register to view this content.
This works really well....except if when there are values that exist in the "secondary" slicer which do not exist in the "main" slicer. The "secondary" slicer seems to keep all values that do not exist in the "main" slicer.
I need a way to fix the code so that the "secondary" slicer only (no more no less) selects the values that are selected in the "main" slicer.
Thanks for your help!