Hi All,
I do have the requirement to show only the latest currency records from the top 10 dates. Was tried analytical functions but didn’t got success. Could you please help me to get the solution?
In the below first example, I would like to display only the first 2 records as currency has changed at the 3rd record.
In the below second example, I would like to display the first 4 records as currency has changed at the 5th record
The currency can change at any date, but it must show only the latest currency records.
Thanks in advance for your help.