Pl attach a workbook to help u
I can't this is all private client information. My screenshot is the extent of shareable information. I can answer any questions about the underlying information, but i cannot share the actual datasource.
Looks like Avg. Net Worth is taking into account the date. So if you drag your date to the Details and use Edit Calculation for Avg. Net Worth and Select Acc Full and Date, It should work.