Hi, I have a chart and a Multi box in the dashboard using different source files. But when I select any value in the Multibox, the chart has to be changed according to selection in the multi box. When I select other list box it should bot change any data even list box and chart is using the same source file. What is the best way to achieve this? Thanks,
You can try using alternate states. Selections in one alternate state won't affect objects in another state. You can create alternate states on the General tab of the document properties window. You can assing an alternate state to an object on the General tab of the properties window of the object.
If your tables are not linked (look at them in the table viewer) then you will also need to add Select in Field actions to the OnSelect field triggers so a selection in one field will result in selecting values in another field. You can add actions to field triggers on the Triggers tab of the document properties window.