The report is grouped on Employee, then position level, and looks like this:

 

Employee ID    Position Level

12345              1

12345              2

44444              1

44444              3

 

In this example, I need to identify that Employee ID 44444 has a gap in the position level sequence. I thought of putting this in a crosstab and then just eyeballing the report for issues, but this is going out to a customer and they'd prefer to just see the problem employees appear on the report only.

 

Any suggestions are welcome. Thanks