Filter Question

[JRandallC]

In Impromptu 7, I have a report of portfolios with a number that respresents each account under that portfolio. Any given portfolio may have one, two or ten accounts under it. I need to remove any portfolios that have a 1 as any one of the account types, no matter how many other account types there are, or what they are.
Of course, removing any account type with a 1 is easy, but I'm having trouble removing any port with a 1 as an account type. In the end, I need to show ports with account types of 2, 3, 4 or 10, but not any that have an account type 1.
Thanks for any help.

Randy

 

[griffindm]

Create a report that filters for portfolios having the '1' account type. Save the report and use it as a dataset for your final report, using a portfolio Not In clause. This should eliminate any portfolios that have a type '1' account type.

Hope this helps,

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"

http://www.decisionsupportgroup.com