Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Jun 25, 2024

Show Last Record

Hello experts,

 

I need to show the last record in another column of this data set based on 2 criteria.

The criteria is I need to show the last record of [MTM] based on the MAX of [Valuation Date] but based on a grouping of [Trade Ref #].

 

I have attached the file with some comments of what I need. 

 

Let me know if its not clear. 

thank you very much. 

 

Resources