My custom report showing each rep's deal amounts by stage is producing duplicate deal amounts. It is counting the same deal amount multiple times for each update to the stage or deal.

This should be a very basic and easy report to create and I'm told this simply cannot be done in Zoho due to the flow? Surely Zoho should be able to make an adjustement on their end to allow for this type of report, no? 

Example: This should show a total of only $50,000 since this is the same deal amount being counted for each time I have saved/updated the deal. That makes zero sense to me!