All,
I'm struggling to find out how to achieve the following:-
I have a list of properties that have had some work done on them:
Property Project
Property 1: New Roof
Property 1: New Kitchen
Property 1: New Bathroom
Property 2: New Roof
Property 3: New Kitchen
Property 3: New Bathroom
I want a report that excludes any property that has had a New Roof.
So in this example, I would only want to see Property 3.
When I do set analysis, I can only get it to exclude the Project of "New Roof", i.e. I get the following table:-
Property Project
Property 1: New Kitchen
Property 1: New Bathroom
Property 3: New Kitchen
Property 3: New Bathroom
How can I get it to exclude it if it has that Project code attached to it? i.e. I want to see
Property Project
Property 3: New Kitchen
Property 3: New Bathroom
Many thanks.
