Problem, is this possible?

[#1]

My problem is that table B is drilling when ik click dimension (group) in table A, i only want table A to drill when ik click table A, and table B when i click dimension in table B.

is it also possible to have the textbox display the corresponding table??

[#2 · Accepted solution]

I think you would need two separate data sets for that to work. When you make a selection in either table, it is making the selection on your entire data set. Since both tables use the same fields and data, that selection affects both. To keep them separate, you would need two sets of data: Set A and Set B. Then when you make a selection on table A, it only affects Set A. Set B remains with no selections.

EDIT: Since you were just using Inline loads, I implemented the split dataset and posted an example.

[#3]

Thanx i allready tried that solution, but was hoping for something easier, because of same facts in all my sheets.

will split my fact tables!

thnx again