Wrong data after applying filter

Screenshot 2025-04-23 at 1.53.06 PM.png

In this bonus pivot table I include 12 reps' bonus by filtering their names(pics below), but when I removed the filter, the bonus for this specific rep changed from $1,982 to $1,902. Then I exported raw data from MySQL and found that $1,902 is the right number which means the filter can make wrong data. Could you help fix the bug?

Screenshot 2025-04-23 at 1.56.16 PM.png

Screenshot 2025-04-23 at 1.55.18 PM.png

 

0 0 35