I am working on a BO report(free hand SQL) where I have two products A and B, a customer has a option to opt for any 1 product or both, the issue is that the amount is repeated twice if he opts for both products and the total revenue is not correct.
How do I make the report to show the amount only one time.
Account # Product Amt
1 A 10
1 B 10
2 A 20
I should have a total of 30
I am new to BO, not sure if this is possible or not, but I would appreciate any help.