14 Replies Latest reply: Mar 22, 2017 12:06 PM by Sunny Talwar RSS

    Pivot Table Total based on different column

    m m

      SchoolSubjectStudentsGradesABCMathab0ABCMathac12ABCMathad32ABDMathae1BBEnglishuu44BBEnglishud0BBEnglishua

      33

      SchoolSubjectStudentsGrades

       

       

       

      SchoolSubjectStudentsGradesClass Total

      Variance

      ABCMathab105510/55
      ABCMathac125512/55
      ABCMathad325532/55
      ABDMathae1551/55
      BBEnglishuu448744/87
      BBEnglishud108710/87
      BBEnglishua

      33

      8733/87

       

       

      How can i calculate Class Total. will it be formulat or set analysis.