2 Replies Latest reply on Nov 1, 2013 8:31 AM by Karl Jensen

    Cascading Filters with Only Relevant Values (Blended Data)

    Ian Conlon

      I've got a dashboard that relies on several different data connections, all blended by a common primary key. I've created a crosstab using data from two data sources. Whenever I add filters to the worksheet, I've noticed that the "Only Relevant Values" option is available only for variables taken from the primary data source. If I add filters from the secondary (or blended) data source, there is no ability to indicate that I want the filter to display only relevant values. Is there any way to make filters from a blended data source cascade based on the results of other filter selections? It's a little confusing, for example, to select the region "Northeast" and see all 50 states listed in the filter for "State" (hypothetical example). Any help would be appreciated.