Please how do I sum up values based on the name of a sales rep? Below is an example of the table I am trying to perform such operations on.
| Date | SalesRep | Amount |
|---|---|---|
| 12/14/2022 | Alvin_KO | 3000 |
| 12/15/2022 | Stan_O | -600 |
| 12/15/2022 | Alvin_KO | 200 |
| 12/17/2022 | Stan_KO | 9000 |