How to use Set Analysis in Aggr?

[Anonymous]

LOAD * INLINE [

Student, Course, Grade

S1, English, A

S1, Math, B

S2, English, B

S2, Computer, B

S3, Math, A

S3, Computer, C

S4, Math, C

]

Student -> Highest Grade

S1->A

S2->B

S3->A

S4->C

How to count only once by mix value of dimension?

I want to get following chart.

Should I use Set Analysis in the expression?

Grade	Count of Student
A	2
B	1
C	1

[Gysbert_Wassenaar]

You can either do it in the script or use a calculated dimension. See attached qvw.