Need an answer for Scenarios

[Jay587]

Hello Community folks,

I need an answer in several ways to the below questions with the table below.

1.get the latest comment ID based in ID 

2.get the latest status based comment ID

ID	Comment ID	Comment
123	1	booked
123	2	shipped
123	3	packed
123	4	closed
345	1	booked
345	2	shipped
345	3	packed
345	4	Delivered
345	5	closed

Please help me on this to get the solution is multiple ways.  Thanks in advance.

[ali_hijazi · Accepted solution]

there is a function called FirstSortedValue
you may use it as follows:
FirstSortedValue([Comment ID],-[Comment ID])
same applies for the Status
FirstSortedValue(Comment, -[Comment ID])

[SRA · Accepted solution]

Hi,

If we consider you need to display the highest CommentID and the corresponding Comment for each ID you could use this :

If you display the complete table with the details, but want to display some new columns with the max CommentID and corresponding Comment you can add a TOTAL <ID> in the formula:

Hopping it will respond to your requirement