Filter a chart by selecting a value from another chart
We have a requirement where we select a value from one chart (say bar graph) and it automatically filters the chart based on the value selected.
I have a bar chart for Territories and their Sales. I have another chart showing the Territories and their Region details.
When I select a territory from a bar chart, I want the other chart to get auto filtered.
Note- We do not intend to use the global filter here which we usually apply at a pinboard level.