I rewrote my example and clarified that the count is by district and race. I just need to combine the counts until they are greater than or equal to10. For example district 1003 shows 7 (eccount), 49 (iepcount) M (multi-racial) students and 12 (eccount), 160 (iepcount) W (white) students. Because the eccount for multi-racial is less than 10, I need to combine it with the 12 white students and add together the iepcount as well as rename the combination race as "combined", or something more appropriate. I used a generic only because I thought it would be more difficult to also combine the race field.
... View more