SAP Analysis: How to filter different reports sharing the same Datasource

[Gunthor]

I am using the SAP Analysis Office Add-In in Microsoft Excel.

I created two reports based on the same Datasource (I created the second via the components tab, selected the datasource, right clicked and selected Insert Crosstab).

However, changing filters for one report always changes the filters for the other report as well. Please assist by pointig me into the correct direction so that different filters can be set.

The idea is to have multipe crosstabs showing different information but using the same datasource. When changing the period via prompt my expectation is that all reports using this Datasource will update and display the figures of the chosen period.