Drilldown to a separate dataset - match by column values?

svetlana ⚪️
edited January 4 in Charting

I need to create a drilldown option that connects to a different dataset (for confidentiality reasons) - but I need this drill down to show the selected category, rather than all data.

For example, I have a card that breaks down employees by country (powered by dataset A). When I click on US employees, I need it to drill down to a table that shows all employees from the US but using dataset B only.

This means that I need to somehow match dataset A and B using country as a key. Is that even possible?

Of note, this has to be a separate dataset due to PDP settings.