Hello Blake - Let me simplify the problem, but still keep the essence of the complexity. The problem statement is the following:
Two sets on the same dimension (Field Name here : Pivot Field Name) has been created for two different type of condition. Now you want to show the common member of the set to the end user. Try to create a combined set by doing a Ctrl+Select the two sets.
This should solve your problem.
This would allow me to make a single filter that has all the values for languages and typefaces, but I'm going for two separate filters. Unfortunately, this won't work, but thanks for your help!
It's been a while, but I'd like to re-post and return to this problem. Manideep's suggestion is getting at my goal, but I want users to be able to do this on the fly, using the dashboard.
Here's another way of looking at this issue: the filters constructed using sets work just fine when filtering the members in the set. For example, here is a Languages Filter with only "Ancient Greek" applied to members in the Languages set:
You can see there are only two titles in Ancient Greek. I have the tool-tip set so you can see the title of the book, "The Illiad." All the titles are in the Dimension "Click to find @ UW"
The trouble is that I want these filters to work together. When the Language filter above, with only "Ancient Greek" selected, is set to apply to another sheet, Books, the other filters (e.g. typeface) seem to be filling in all values. You can see I'm returning a lot more than just two books.
It may be that I'm misunderstanding the issue! But it seems like the overlapping filters are the source of my problem.
Please let me know if you have an insight on how to get these filters working together!