Hi again,
I have two crosstabs that filter each other's context. (So it's not a master detail relationship since both can be masters).
Let's say the first has Revenue / Productline
the other REvenue / OrderMethod
if I drill down on the Ordemethod then not only the second crosstabs gets drilled down but the first one will show REvenue / Product line for the given Order methods (result set of drilling down on the sencond Xtab.)
and vice versa.
I can do it if I use one query, but now I have two different datasource I have to use two queries.
What's the solution? I tried with Union, doesn't work. I defined the member sets but no impact.
Thanks
Bence