Every time a new estimation of the value is made a new line is added. This line has a number; the higher this number the more recent the estimation is.

 

For example, a relation has the following lines in this table: 

 

Est_number Estimated Value

1                 €100   

5                 €75

8                 €150

 

Now I only want to see the value €150 in the report, which should look like:

 

Relation Most recent estimated value

A           € 150 

B           € 200

 

Thanks for helping me.