Duplicates in the display

[#1]

Dear QV Experts

When i select the Month ' July' from the list box, i was surprised to see one additional rows.

After analysis i found due to the Newserv Id, though the Acknowledgement Sent Date Column in Jan 2016, it displays in July 2015.

The Expression used,

= Count({<DateType = {'Received'}>}Acknowledgement)

Can you please suggest me how to get rid of this duplicate row.

[swuehl · Accepted solution]

Maybe like attached.

I've removed the syn table by dropping one table and changed the key for the link table.

[#3]

Excellent. The same was expected. Thanks a lot.