6 Replies Latest reply: Mar 7, 2018 3:59 AM by Larry LI RSS

    How to set selected dimensions when start in QS

    Larry LI

      Hello, friends.

       

      I met a problem need to be solved. please read the description below.

       

      for example, i have a table as below.

      DimensionMeasure
      A2
      B4
      C3
      D5

       

      by default, if i do sum(Measure), measure is 14.

      and i can select Dimension A, then measure is 2.

      it is ok for me..

       

      now, i want to do sum({<Dimension={‘*’}-{‘B'}>}Measure) as default result (10) when i open the report.

      later, if i  manually select the Dimensions A-D, the Measure result is 14.

      that means B is not really filtered. it is just not taken into account at the beginning.

       

      any solution for that?

      thank you very much.

       

      BR

      Larry