3 Replies Latest reply: Sep 27, 2011 6:02 AM by Sunil Chauhan RSS

    Hidden dimension and calculation

    Vivien TEXIER

      Dimension level 2Sum ( A & B )Sum ( C ) /  Sum ( A & B )
      AlphaAANull
      AlphaBBNull
      AlphaNullNullC

       

      Hi,

       

      How can I hide the third line of my table (where dimension level 2 = null) and keep the result of my expression (Sum(C) / (Sum A & B) in the same time ?

       

      I can make all values of the third line equals to null but the line doesn't not disappear.

       

      In table properties, if I chose to not display null values the line disappear but my calculation ( Sum(C) / Sum(A & B) ) as well.

       

      How can I hide the third line and keep my result ?