Forum Discussion
Multiple Interactions Not Working Between Charts
When clicking on a chart that filter two other charts then clicking on a second chart that filters the third the first filtered is removed. Example: Chart A: Sales by Year (Displays 3 Years) C...
In your example, since Chart B filters only C, after you click on Chart B for a specific product, Chart A will be no longer clicked. But Chart C should be still filtered. Please refer to the following video.
I think a better solution is to make Chart B filter A and C instead of only C. Please refer to following video.
Best Regards,
Herbert
You are seeing correct results only due to the way your data is setup. If Sales Rep M1, sold products in other years other than 2015 or A1 was sold by another rep your results would not be as you expected. Add to your dataset the following:
Year, Product, Rep, Sales
2016, A1, M1, 5
2015, A1, M2, 10