1 Reply Latest reply: Sep 24, 2012 10:30 AM by Daniel Fleisher RSS

    Set analysis question

      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