This content has been marked as final. Show 3 replies
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
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!