Set analysis question

[#1]

Hello everyone

I have two pivot tables one that has a dimension  "DIM1" and the other contains a dimension "DIM2" that is inferior (in hierarchy) to the dimension DIM1. if i filter on the second dimension it filters on DIM1 as well. what i want is for the exppression of the first table not to be affected if I select a value in DIM2.

PS: I have already tried  to put this in the expression "DIM2=,". but it doesn't work. the fact is If i select a value in DIM2 the other dimensions are affected by this selection as well, do i have to mention all of the dimensions of the app in the expression "DIM2=, DIM3=, DIM4=, DIM5=....etc"

Thank you so much in advance

[danielact]

If you're using version 11, you can try using alternate states for this. Set up an alternate state and do set analysis with {$<DIM2={AltState}DIM2>}