Filter the last 'state' of a data item

[MKlepper]

I have a report with data items that can/will change their 'state' over time. I need to only show the last 'state' of these data items.

Example: Report results with no filter (state 1 ends in 00, state 2 ends in 01, etc.)

abc12300
abc12301
def12300
ghi12300
jkl12300
jkl12301
jkl12302

The final report with filter should only show:
abc12301
def12300
ghi12300
jkl12302

[ramscognos]

with the help of trim fns we can get that data items alone.. try it

[bdybldr]

Take the max of the states.  For example, MAX([State])