How to export deals by product?
Hi there. I'm using zoho, and I need to export all my deals to analyze them with Power BI, but when I export my deals, I get one row per deal in which the ammount is the sum of all the products on that deal.
What I need is to get a row per product per deal. Is this possible?
Example: I have a deal associated with 2 products (each one with an ammount of 500). What i currently get is:
Deal 1 | Ammount 1000
What i need:
Deal 1 Product 1 | Ammount 500
Deal 1 Product 2 | Ammount 500
Thanks in advance