Hi @ch411951 , welcome to the community.
I understand how important it is in business to have reports that are accurate. We're here to help!
We can customize the Sales by customer report to show the total sales by customer by using the filter option and select the relevant items from the list. I've provide and article the will give step-by-steps instructions of how to customized your report, adjust the steps to suit your reports needs. Here is the Aritcle
Feel free to reach out again if you need further clarifications. Have an amazing Monday!