If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Filter Based on if a condition is met within a set

Started by anthus, 03 Aug 2010 03:30:22 PM

Previous topic - Next topic

anthus

Hi all.  I have another question.  I'm creating a list report (8.4).  I have modeled this data in both DMR and Relational so I could build the report either way but I'm not sure which is the best for this situation.  The situation is that I need to filter my report based on if a field is >0.  The data is grouped by Region.  So, I only want to show that Region if one of it's States has a negative number.  If the State has a negative number then I want to show all states for that Region.  I'm not sure how to go about that.  I can filter to just show only those States with a negative but that's not what I need.  If a Region has a State has a negative number than I need to see all states for that Region.  Any help is greatly appreciated.

Report layout is as follows:


Region (section)
State (group) |  % Available

Objective:  Create a report that shows only regions that have a State with a % less than 0.  Show all states for that region.

Thanks.....Anthus

anthus

I was able to figure this one out on my own.  I used 2 queries and then joined them.  The first query I filtered to get my list of regions and states with % <0.  The second query I put a filter on to filter where query2.region||state in 1st query.requion||state.

...Anthus