Displaying a flowfield based on a flowfilter on a list page

poppins

Hi everyone,

I have a flowfield "Max Date" in a custom table TAB1 with a following formula: Max(tableXXX."Posting Date") where ("Customer No."="Customer No Filter") where "Customer No Filter" is a flowfilter(can be one customer number like 10000 but it can be also something like 1000..3000).

When I added the flowfield to a Card page based on TAB1, the value of "Max Date" was displayed correctly.
But when I tried to do the same thing in a list page, the flowfield shows wrong values(probably because of the changing flowfilter).
How can I do to get a correct value of the max date(if it is not possible with the flowfield, any suggestions?)

Thanks in advance