Pivot Table Total based on different column

[userid128223]

SchoolSubjectStudentsGradesABCMathab0ABCMathac12ABCMathad32ABDMathae1BBEnglishuu44BBEnglishud0BBEnglishua

33

School	Subject	Students	Grades

School	Subject	Students	Grades	Class Total	Variance
ABC	Math	ab	10	55	10/55
ABC	Math	ac	12	55	12/55
ABC	Math	ad	32	55	32/55
ABD	Math	ae	1	55	1/55
BB	English	uu	44	87	44/87
BB	English	ud	10	87	10/87
BB	English	ua	33	87	33/87

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

[sunny_talwar]

In case Aggr() makes you happy (which doesn't make me happy because it effects performance), you can use this

Sum(Grades)/Aggr(NODISTINCT Sum(Grades), School)

[userid128223]

Hi Sunnny

Would the formula work the same way if aggrigation was "Count" and not "SUM"

[sunny_talwar]

I believe it would...

[userid128223]

Class Total

count(TOTAL <School, Subject> Grades) ?

Variance

count (Grades)/Sum(TOTAL <School, Subject> Grades) ?

or do we have to rewrite it differently.

[sunny_talwar]

More like this

Class Total

Count(TOTAL <School> Grades)

Variance

Count(Grades)/Count(TOTAL <School> Grades)