Retrieve a value from another field on another line in the same table

[danny_vd_vuurst]

Hi there,

I think I have a fairly simple problem to solve, but I can't find the solution.
My QVW. file consists of one table which is monthly updated with new records for that month.

Columns B:F are delivered in the source file.
I need to add column G and this should be filled with the value from column F 'reset_date' from the record line 'file_date' corresponding to the value in field 'file_date_previous_reset'.

I hoped this would work:

max({$<file_date = {"=file_date=file_date_previous_reset"}>}  reset_date)

But I wouldn't be here if this works...

Any help is greatly appreciated!!

Thanks,
Danny