Thanks for your reply.
I had tried this on my actual sheet, but i read that exclude filters give a performance hit, but yes this works great for smaller data sets.
I think it works without the lookup function as well.
Simply using machines on filter shelf and then using atleast 1
1 of 1 people found this helpful
Current location = scrapped was still shown in that caclulation.
I have modified it like this :
NOT ISNULL([Machines]) and [Machines] <> 0
Please edit your answer with the above and i can mark your answer correct.
There are multiple ways to do this. I showed you one only.