Connections Between Data List Boxes Creating Duplicate Data Items

[josephg123]

Hi,

I'm having some issues when using multiple data list boxes to filter a graph showing a measure.

I can get all the data list boxes to filter the graph accordingly, however the issues occur when I try to connect these list boxes together. The is to have the filters working were I would select a data item on one filter (e.g. year) and it would filter the other filter boxes to show data that only appears in that year.

To do this I have added a filter to all of the data list boxes to be filtered by each of the variables from the other list boxes. For this, I also have to put in all of the different filter data items for each of the seperate filters in 'extra items'.

This works in the sense that when I click on one data list box (e.g. year) it will filter another data list box (e.g. product) to only show the products that appear in that year. However, when none of the data is selected within the list box then there are duplicate items within each of the boxes. For example, because a product appears in 8 of the 12 years, it will appear 8 times on the product filter because it has the year data item within its 'extra items'.

Is there any way to stop this happening and aggregate the data to get rid of the these duplicates? This also greatly affects the speed of the report when it is run as there are more data items.

I'm not sure how well I have explained it so feel free to ask further what I mean by this issue.

Thanks,
Joe