I'm having a problem applying filters that are limited in scope. Let's say I have a Matrix with two fields in it:
City
Customer
I expand the City of "Chicago" and see all of the Customers in it. Now I pick a Customer named "ABC Parts" and do a drillthough on the Customer Name which brings me to another page. Whatever other visuals I end up at will not only be filtered to show me "ABC Parts", but will *also* only show me data relevant to Chicago. I don't want this. When I find the Customer I'm looking for, I want to see ALL activity for that Customer, regardless of City.
I even tried putting the City in one table, which brought up a list of Customers in a separate table, and then did my drillthrough on just one Customer in the second table. This *still* applied a limitation (by City) on the drillthrough page (there was a separate drillthrough criteria that said "including 1 other" or something like that).
Is there not a way (aside from telling the users to jot the Customer name down on a post-it note and go to a completely separate page to type it in there) that I can allow my users to browse through data by category and then pull up ALL information related to a specific field once they've found it?
