4 Replies Latest reply: Feb 14, 2017 12:02 AM by Pratyush Shastri RSS

    Pivot table count on condition

    m m

      I have following kind of table

       

       

      SchoolSubjectStudentsGrades
      ABCMathab0
      ABCMathac12
      ABCMathad32
      ABDMathae1
      BBEnglishuu44
      BBEnglishud0
      BBEnglishua

      33

       

      I want to create pivot table like below

        

      SchoolSubjectCount with Grades > 0Count with all grades
      ABCMath34
      BBEnglish23

       

       

      How can i achive above pivot tables.