Hi,
I wan't to compare data with some alternate states.
So I have 2 tables in two different states. ST1 and ST2 or in the default which is not clear for me how to set it.
To have my filters and calculations done there is no problem they are linked to the state I needed ST1 or ST2 and with set analysis I got my results.
Now we have several dimentions linked to those tables to show and hide column in both tables that are in the default state.
So for example if I show the year column it shows the year column in both tables. If I select a year filter for ST1 then I got my result for ST1 and if I select my year filter for ST2 then I got my result for ST2 which is working fin.
But now when I wan't to drill down on my year dimention in the ST1 table it uses the default state and changes the time in both tables.
So how can I link that dimention that needs to be made visable in both tables in one table to ST1 and in the other table to ST2.
If I duplicate my dimention selectors then this will work but then I have to double more then 40 dimentions and makethem available on the screen which is not a good idee I think. Is there a way to accomplish this?
Thx
