Trying to create a setup where I have a Sales Rep. that may cover another territory. These territories are defined by Customer Accounts. The same account may be in 2 different territories. As long as the Sales Reps names are on the report the totals will be accurate. The Grand Total will not. But if the Sales Reps are not on the report the Totals will have some Sales duplication. This is due the the fact the the same account sale will be on each Rep.
Example:
Rep 1
Account 1: $1000
Account 2: $1000
Account 3: $1000
Rep 2:
Account 3: $1000
Account 4: $500
Account 5: $500
Rep 1 is covering Rep 2's territory
Report 1:
Rep. Total
Rep 1 $3000
Rep 2 $2000
Total $5000 (This should be $4000)
Report 2:
Total $5000 (This should be $4000)
How can I setup the BMM to do a Sum Distinct on the sales by Account here so my Total removes the account duplication?
