How to use Set Analysis in Aggr?

Anonymous — Thu, 08 Aug 2013 13:06:42 GMT

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?

Re: How to use Set Analysis in Aggr?

Gysbert_Wassenaar — Thu, 08 Aug 2013 13:34:09 GMT

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