COGNOS Filter

[peewan]

Hi, I need help with filter on my report.
I would like all ID in Ed=Y and IP = N. and I also want if IP = Y in any line in the same ID, this ID will be excluded also

For example,
ID =18056 had 2 line, I do the filter on ED = 'Y' and IP = 'N', it still show ID = 18056


Set   ID          LA_NM FST_NM       DOB               ED   IP Stay
E   18001   CHA   ANDRESS   Jun 2, 2017      Y   N
E   18056   CHA   ANDRESS   Jun 2, 2017      N   Y
I   18056   CHA   ANDRESS   Jun 2, 2017      Y   N
E   18041   CHA   ANDRESS   Jun 2, 2017      Y   N
E   18041   CHA   ANDRESS   Jun 2, 2017      Y   N

Thank you!

[srmoure]

Just create a 2 filters :
A) [ED]='Y' AND [IP] ='N' 
B) [IP] <>'Y'

If you want to use only one filter A) or B) should work

[peewan]

this work!