I'm a CR newbie and have encountered a situation that is bending my noodle a bit.

I have a report where in some of the rows the data in the columns is identical except for the last column, which can be one of 3 kinds of identifiers: Pxxx, PMxxx, or Cxxx. So the conditions I need to satisfy are:

a) the row should only be displayed once
b) IF the identifier in the last column is PMxxx it needs to be displayed, otherwise it doesn't matter what the identifier is as it will be suppressed and just left blank.

So to clarify the report kind of looks like this:

aaa bbb ccc 1234 P12345
aaa bbb ccc 1234 PM88654
aaa bbb ccc 1234 C00123

in this case I only want to show:

aaa bbb ccc 1234 PM88654

If the data was:

aaa bbb ccc 1234 P12345
aaa bbb ccc 1234 C00123

then we would only show:

aaa bbb ccc 1234

How the heck can I accomplish this?

Thanks!!

K

Thanks!!