Pivot Table reflect the latest value in a dimension (FirstSortedValue does not work)

[fishing_weights]

In continuation of: Qlikview-Pivot-and-flag 

I've a pivot table with grouping in the expression and partial sum for the dimension.

How do i get a dimension to reflect the latest value base on the date selected?

I've tried:

FirstSortedValue and Max in the dimension but both does not solve the issue.

attached is the sample data and the QVW sample. Thanks in advance

[fishing_weights]

anyone got any ideas here?