I may have missed the gist,
but it appears to me that your setup is working,
as demonstrated by clicking on the material 000094.
I think it is the excess over 40 days filter that is causing
all the rest of the blanks.
I removed that filter on the sheet "no 40d filters" and you
can see that items do show up.
Please see workbook v10.2 attached in the Forum Thread.
287641filter_v10.2.twbx 83.9 KB