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?
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 |