Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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>}