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!

(1) Answer

Login