7 Replies Latest reply: Jan 25, 2016 1:42 PM by Djallel SADKI RSS

    sub total with if condition, aggr

    Djallel SADKI

      Hi,

       

      if any one can help

       

      I have a pivot chart with two dimensions, the first one is dim1 = course and the seconde dim2 = student

       

      I want to count the number of student who have a final note <8 AND number of absence <=2

       

      so i used a simple expression that calculate the number of student who have a grade <8 and another one with the number of absences

      and create a third one (the one i want) like below :

       

      if([Unauthorized absence]<=2 AND [Grade< 8]=1,Count(DISTINCT STUDENT_KEY))

       

      not working...so i used an aggr function but that still not working

       

      summary :


      Dim 1 = course

      Dim 2 = student


      Expression 1 = [Unauthorized absence]

      Expression 2 = [Grade< 8]


      Expression 3 = if([Unauthorized absence]<=2 AND [Grade< 8]=1,Count(DISTINCT STUDENT_KEY)) ??

       

      thanks for your help

       

      best regards,