Custom Crystal Report is showing multiple transactions for each customer

Hello. I have created a custom Crystal report showing sales by Salesperson code. I realize there is a "standard" report in Sage already, but our director is wanting one that exports to a clean Excel format. A couple of issues...

1. The custom report is showing ALL transaction for each customer, by period and Salesperson code. How do I only show ONE customer record per Salesperson code and their total dollar amount spent for that particular sales order/invoice?

2. I was able to locate the Gross Profit Amount field for this report via the vSalespersonSalesHistory table - where do I find the Gross Profit Percentage field (which table)?

Thanks in advance for any assistance!


T. Helm