Use one single filter to control two chart
I have two tables. [Agent] -[ Sales] and [Agent] - [Working date] ( both tables have duplicate entries ).
I created 2 charts
chart that shows Sum of sales Per agent
chart that shows number of working days per agent
I want a filter that when you select agent name, it dynamically change both charts.
Thanks you for help!