Dependent Variable did not refresh value
Posted: Thu Mar 07, 2024 6:55 am
Hi,
I have the following data
Year, Month
2023, 12
2023, 11
2023, 10
2022, 5
2022, 4
I created 2 variables (Year and Month) with 'Month' is dependent on 'Year'
Both of which has the initial selection set to First and both sort by descending
When I first load the report, my Year is set to 2023, and month is set to 12 (Which is correct)
However, when I change Year to 2022, Month is still displayed 12 (but the dropdown selection is updated to 5 and 4).
It does not dynamically change to 5. Is there a way around this?
I have the following data
Year, Month
2023, 12
2023, 11
2023, 10
2022, 5
2022, 4
I created 2 variables (Year and Month) with 'Month' is dependent on 'Year'
Both of which has the initial selection set to First and both sort by descending
When I first load the report, my Year is set to 2023, and month is set to 12 (Which is correct)
However, when I change Year to 2022, Month is still displayed 12 (but the dropdown selection is updated to 5 and 4).
It does not dynamically change to 5. Is there a way around this?