Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have a report with class grade distributions - the rules are that we cannot show class grade distribution if class size is less than 10 OR if only two grades were assigned and only one person received one of the two grades (on the assumption that that person would know that everyone else got an A when they got a D for example).
Here is a sample of the pivot chart:
Grade Distribution | |||||
Class | Total | A | B | C | |
100 | 35 | 10 | 20 | 5 | Display this row |
200 | 7 | 2 | 3 | 2 | Hide or show Nulls: N <=10 |
300 | 16 | 1 | 15 | 0 | Hide or show Nulls: Only 2 Grades and n = 1 for one of the grades |
My Expression is as follows:
if((Count(Total <[Class]> [Student_ID]) <= 10)
OR
(count(Total <[Class]> [Student_ID]) -
max(Aggr(Count([Student_ID]), [Class], [Grade])) = 1
),
Null(), count([Student_ID])
)
Which results in this (close but not quite there):
Current Results | ||||
Grade Distribution | ||||
Class | Total | A | B | C |
100 | 35 | 10 | 20 | 5 |
200 | ||||
300 | - | 1 | - | - |
Any suggestions on how I can get that A in class 300 set to NULL as well?
Thanks in Advance
Please check the attached, not sure if this is what you asked for
Thanks, but that's not quite it. Grades is a field with values of A, B, C, etc including A+, A-, etc. A, B, C are not separate fields.