Pivot Table gives wrong sum after using "Remove Duplicates" for Excel Tables on the source table

I was following a youtube tutorial on Tables, and from an example table, It seems like a value from a deleted row is still part of a sum in a pivot table.    I am referring to a duplicated row (wit...