Hi,
When Im setting up controls in quicksight analysis, i opt for ‘show relevant values’. what it does is, Control A’s dropdown list changes with respect to selected values in Control B. but when i change a value in control B, the already selected value in control A remains selected (which is not supposed to be an option for the newly selected value in Control B) and I have to manually change it to the relevant value which is loaded in control A. Is there a way to change this behaviour? I want the selected value in control A to change to what ever the first value in Control A dropdown relevant to changes made in control B.
Thanks