- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Excluding Dimensions that meet criteria
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use E(), something like:
sum( {$<Property= E({1<Project={‘New Roof’}>})>} Sales )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use E(), something like:
sum( {$<Property= E({1<Project={‘New Roof’}>})>} Sales )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks a lot Tresesco