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
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
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 greatAnnouncing #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 TemplatesIntroducing 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 versionAnnouncing #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
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー