Best is to share an example for us to try.
But here is an idea. (Might not be the best one):
How about having a calculated field to link all those filters?
IF[Filter1]=[Filter2]=[Filter3]=[Filter4]=[Filter5] THEN TRUE ELSE FALSE END
and you drag this one to your filters and set it as True.
Then you add any of your real filter as selection.
Does it work?
Here you go Morgan. I tried to write the calculated field but I'm getting an error.
IF ATTR([Theater]) = ATTR([Account_Snapshot (SFDC)].[Theatre]) = ATTR([Monday PQL Report for BDRs (SFDC)].[PQL Theatre])= ATTR([Monday Curr and Hist Reporting for BDR Pipeline (SFDC)].[Theatre]) = ATTR([Monday Curr and Hist Reporting for SBDR Appts (SFDC)].[Theater]) THEN "True"
Testing 2.twbx 3.1 MB
Hi Morgan, I attached the file below.
Hmm indeed, you cannot have more than 2 =
You could also use a action filter may be? If all sources are linked on Theater part (Which is the case), it should work.
You could put in Columns the field Theater, do some formatting and add this worksheet to your dashboard + enable the action filter.
Does it work in your case?
But actually, in the version 10, you can know do it automatically. You can filter cross datasource. (Just found out now)