Report to Show Total Sales per person

Hi Mandi,

The issue is you are reporting across two modules, the accounts module and purchases so it will be giving you duplicate data. 

You are better off just reporting on the purchases module  filtering by your date periods on a run time and grouping by the assigned user and account record related to the actual purchases.

Thanks

Joe

Thanks Joe, I did try that but all purchases are uploaded by the admin not manually added by the assigned to person. So when I put 'assigned to' in the purchases module, it only pulls admin. The total purchases field is only found on the Accounts as it was a custom field that I created to calculate all order amounts from each purchase entered (in the purchase module) into one field to show the total for that account.  I am looking for a report that will just pull the exact amount that is in that field (from the account module), who the account is assigned to and then when the orders were added (from the purchase module). Even when I start with the purchase module and try to pull a sum of all of the order amounts, it is still duplicating. 

 Nord Herida can you help with this. 

 Nord Herida can you help with this.