Please find my solution attached.
My understanding is you need change below calculation fields as shown below, I guess you don't want double counting the duplication rows
and the view will looks like below
Hope this helps
Sample Workbook v0.1_v10.2.twbx 63.3 KB
Thanks ZZ! That really helped!