I have a parameter Y that is supposed to get refreshed according to the values set in parameter X which is fetching values from a query and is single select value.
My issue is that it is getting the values properly the first time but when the X parameter is changed the Y parameter remains same. I want the Y parameter to load the default value every time X parameter is changed and also the Y parameter to be editable so that the end user can change the values as desired if he wants to. Can anybody give some suggestions.