Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Table:
Dim : ID
Exp1 : Max([Step ID])
Exp2 : FirstSortedValue([Step Description], -[Step ID])
Table:
Dim : ID
Exp1 : Max([Step ID])
Exp2 : FirstSortedValue([Step Description], -[Step ID])