I've attached a sample workbook showing one way to do this. Create a calculated field similar to the following:
if window_min(sum(Grades))<=80 then 'exclude' else 'keep' end
Then, place the calculation on the level of detail shelf. Right click on it and select Compute using-->Courses. Right click on it again and select Filter... Then, choose 'keep.'
Hope this helps!
only students above 80.twbx.zip 12.2 KB
Thank you so much! Perfect!