Excluding Dimensions that meet criteria

Karl_Hart — Tue, 21 Oct 2014 12:48:42 GMT

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.

Re: Excluding Dimensions that meet criteria

tresB — Tue, 21 Oct 2014 12:54:42 GMT

Use E(), something like:

sum( {$<Property= E({1<Project={‘New Roof’}>})>} Sales )

Karl_Hart — Tue, 21 Oct 2014 13:13:30 GMT

Thanks a lot Tresesco