Show last step

[muhaab88]

Hi

I have A question ....

I need to show the last step of each ID using set analysis as below table....

ID            Step ID                        Step Description

1                   3                                      Delete

2                   2                                       Paste

3                   5                                        Move

I have the below table containing these data...

ID	Step ID	Step Description
1	1	Cut
1	2	Paste
1	3	Delete
2	1	Cut
2	2	Paste
3	1	Cut
3	2	Paste
3	3	Delete
3	4	Copy
3	5	Move

[tresesco · Accepted solution]

Table:

Dim : ID

Exp1 : Max([Step ID])

Exp2 : FirstSortedValue([Step Description], -[Step ID])