Filtering out a Parent and all it's children ONLY IF they ALL meet a criteria
I'm trying to figure out a way so that if a row meets a certain criteria (aka Status = Complete) and the row's PARENT also meets that criteria, then the rows AND the parent are filtered out. If the parent is NOT complete, I don't want ANY of the rows under that parent filtered out. Anyone have any ideas how to accomplish this??