Dynamic Input to Query Prompt Selector

Hi Folks,

I have a scenario in dasboard, where I am using 2 queries built on top of universe. Query 1 uses prompt Geo Hemisphere.

And query 2 uses prompt Geo Region. Geo hemisphere and Geo Region are interlinked at the backend.

Here goes the requirement:

I make a selection under prompt 1, Geo Hemisphere, say 'Western', I should be able to see only those Geo Region that comes under 'Western' under prompt 2. Is this requirement achievable using query prompt selector??? If so, how can we achieve it??

Thanks and Regards,

Aravind