Two pass filter

[Kaiaualad]

I have data as this:The Header is a parent of the Fixed.
I need to filter out Headers whose ID = NULL, then take the number of the NULL header and filter out all other rows with that number (1041) in it.
Is this possible without using a view or dataset filter? Datasets get corrupt on MR1 and we have difficulty getting approvals for views on production.

ID Type number
123 Header 1039
NULL Fixed 1039
NULL Fixed 1039
456 Header 1040
NULL Fixed 1040
if NULL Header 1041 <- filter out this value
NULL Fixed 1041

 

[DoubleD]

Unfortunately, I am not aware of any solutions other than a View or Dataset filter. If this is a common need, you should be pushing back on your database group to get a view created. If they are not willing to accomodate, you're in for a painful ride as a reporting person.