3 Replies Latest reply on Oct 14, 2013 9:34 AM by Russell Christopher

    Data Blending: Is it possible to show just 'Only Relevant Values' for a blended dimension coming from the linked data source?

    alberto aguero

      Is it possible to show just 'Only Relevant Values' for a blended dimension coming from the linked data source?

       

      here's what i'm doing

       

      I have a summary tab

      COUNTRY  POPULATION

      USA      100

      SPAIN    50

      UK       75

       

      and a detail tab

      COUNTRY  PRESIDENT VOTES

      USA      BILL      200

      USA      OBAMA     250

      SPAIN    JOHN      150

       

      what i've done is to link both data sources by country but the idea is to add two filters

        - one for COUNTRY

        - and another for PRESIDENT

      the COUNTRY filter should show all countries from the summary (even if there's no detail for it)

      and the PRESIDENT FILTER should show just the Only Relevant Values from that Country

       

      i.e if I select USA i do not want to see the Spanish President

       

      is that possible to set 'Only Relevant Values' for a blended dimension?

       

      attached a screenshot and the worbook

       

      if I do it in the reverser way, the issue is that I only see the Countries included in the detail

       

      thx for your feedback!