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. 

​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.    Read More

​