I have a grid that shows a detailed list of items. Below that, I show a number of pie charts that show the breakdown of the list category totals, so the grid and the charts use different data sources/ queries since i need grouped totals for the charts.
However, when filtering the grid, I would like to be able to get and apply the same filters to my pie chart data sources. This way they will show the correct totals based on the filtered grid.
What is the best way to apply the same filters from the grid on to the pie charts on the grid filter event?