Hi,

we currently have a simple setup for our deals and analytics: A deal has one product and one amount. In the analytics we then simply can filter per product and amount in a deal to see, which product is selling the best, etc.

But now we want to add more products to a deal. I already added a multi lookup and created a linked module with Deal x products.

But the question now is, how do I create the amount per product? So we can also check the analytics? I can't use the unit price, as we often give discounts for bundle orders, etc.

And best case scenario is, that the standard field "Amount" is the sum of all product amounts.