4 Replies Latest reply on Jun 15, 2012 7:21 AM by sinadashtipour

    Filters to affect multiple datasources


      Hello All,


      I'm trying to apply a filter to two different data sources.


      Please see the attached workbook. If you look at the Drill Down tab you can see that when you change the filter (Download Year) it only affect the No of Downloads column, but it doesnt affect the No of Uploads because that is coming from the Uploads data source.


      Is there a way to make sure they are both affected. So for example when you change the Download Year to 2012, it should also change the Upload Year (from Uploads datasource) to 2012.


      I hope I have explained this clearly.


      Many thanks,in advance