8 Replies Latest reply: Jul 10, 2012 12:17 AM by Kiran Rokkam RSS

    Distinct count total in Straight Table

      I have a straight table like below;

       

      Dim1Dim2Dim3Expr1
      1........0
      1........0
      2........1
      2........0
      2........1
      3........1
      3........0


      TOTAL2

       

      Dim1, Dim2 and Dim3 are Dimensions and Expr1 is an expression.

       

      Expr1 takes the value of 1 or 0.

       

      Expr1 can be 1 for more than once per Dim1 (eg, Dim1 =2 has Expr1=1 twice)

       

      Please help me to get the  distinct count of Dim1 when Expr1=1 and display it in  the Total Row.

       

      (Total value does not need to be in the same column as Expr1, adding another expression is acceptable)

       

      Thanks in advance.