In my dashboard, I want to compare the values for the countries for different cob_date, so I create two pairs of cob_date list box and bar chart, and put them side by side. I assign each pair a separate alternate state - State1 and State2 accordingly. Below is the screen shot when I select 5/31/2019 in State1 and 4/30/2019 in State2:
Now I want to add a country list, and this list should work for both states, meaning when I select a country, both bar chart should show data for this country only.
What I did is,
1. Add a Listbox of country field. the List Box is in <inherited> state.
2. Add a triggers in "Document Properties" on country field event. In this event, I copy the state to State1 and State2.
The issue is, whenever I make a selection in the country list, the two cob_date listboxes will be reset to all. So any prior selections I made in the cob_date boxed will be lost after I click in the country list box..
So my question is how to make it work so the selections in each state will keep when a country is selected?