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

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Topic Participants
dumejo92

Sticky Posts
Introducing Bigin 360: Our new pricing edition with increased feature limits and pre-installed toppings
Dear Biginners Club, Today, we're pleased to launch a brand-new pricing edition called Bigin 360, our highest pricing edition that will sit on top of Express and Premier editions. It's been over four years since our launch, and we're receiving some great
Announcing #BiginnersClub meetups in US, Middle East, India & UK (Free Event)
Exciting news, Bigin enthusiasts! #BiginnersClub meetups are back, and we're hitting some major cities this time, starting from October. Here's what you can expect: Meet our experts face-to-face Deep dive into Bigin and its advanced features Personalised
[New] Create invoices and contracts in minutes with Zoho Writer's Merge Templates for Bigin!
Do you often find yourself manually entering customer information in your business documents like invoices and contracts? This can be a time-consuming process that can take up valuable time from your business operations. With Zoho Writer's Merge Templates
Introducing Forms: Streamline data collection with Bigin's new form builder.
Hello everyone, Bigin's web forms just got a makeover! We are excited to introduce Forms: an online form builder designed to meet all your data collection need. This revamp was inspired by your feedback, resulting in an upgraded and versatile version
Announcing #BiginnersClub meetups in India, Middle East & Africa, and UK
Yes, you heard it right! #BiginnersClub meetups are back. Whether you're a long-time customer looking to learn more about Bigin, or a new customer trying to explore Bigin, our in-person meetup is definitely the right place to get a deeper understanding