Urgent Report Inquiry - Removing Duplicates

Urgent Report Inquiry - Removing Duplicates

Hello Team,

I need your urgent support please to create a proper report. 


I am trying to get a report on all the actioned opportunities(=Deals) on a weekly basis. The fields to be displayed are Opportunity owner, stage and opportunity name in 3 consecutive columns.

By actioned, I mean anything that has some activity, or notes or emails sent by the opportunity owner only. 

So I went to summary report, chose the main module as opportunities, and the other modules as notes, email and activities. 

Then I added  the below filters. (Images are also in the attached filed)

 
  image.png

image.png


The problem is it gives the count based on the number of activities, so it counts the opportunity name twice or more. What I want is to get the total umber of unique opportunity names.  I tried to edit columns to total, but opportunity name is not listed there. 


Is there any custom function I can add so it doesn't duplicate the opportunity name?

    Zoho Developer Community






                              Zoho Desk Resources

                              • Desk Community Learning Series


                              • Digest


                              • Functions


                              • Meetups


                              • Kbase


                              • Resources


                              • Glossary


                              • Desk Marketplace


                              • MVP Corner


                              • Word of the Day



                                  Zoho Marketing Automation
                                          • Sticky Posts

                                          • Zoho CRM Plus in 2023: Let's rewind

                                            Hey everyone, There's something about December that makes us want to sit back and remember all the wonderful moments, as we get ready for the New Year, 2024! (Psst! We are also turning 10—yay!) This year, CRM Plus had a lot of wonderful updates, taking
                                          • The CX Workshops are back in 2023!

                                            Hello, can you see my screen? Can you hear me? This is a phrase we've all been saying more often than "good morning" over the last couple of years. Well, now it's time to re-connect in person. We're excited to invite you all to the CX Workshops we've
                                          • Refer Zoho CRM Plus to your friends and earn rewards!

                                            Hey everyone,   We'd like to thank you from the bottom of our hearts for continuing to be our esteemed customers. Now you have the opportunity to refer Zoho CRM Plus to your friends or family members who are looking for a suitable solution to enhance
                                          • Social in CRM Plus now supports TikTok, Instagram Stories and Reels, and YouTube Shorts

                                            Hey everyone,   We are excited to inform you that Social in CRM Plus now allows you to publish on TikTok! We've also updated it to let you create Instagram Stories and Reels, as well as YouTube Shorts. Here's a brief about the updates.  Publishing on
                                          • Unified telephony in Zoho CRM Plus

                                            In any business, managing calls with the prospects or customers is an integral part of a salesperson or a support agent's daily life. They have access to information about the customers within Zoho CRM, and they also use a suitable PBX service to communicate


                                          Manage your brands on social media



                                                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 WorkDrive Resources



                                                                    Zoho Campaigns Resources

                                                                      Zoho CRM Resources

                                                                      • CRM Community Learning Series

                                                                        CRM Community Learning Series


                                                                      • Tips

                                                                        Tips

                                                                      • Functions

                                                                        Functions

                                                                      • Meetups

                                                                        Meetups

                                                                      • Kbase

                                                                        Kbase

                                                                      • Resources

                                                                        Resources

                                                                      • Digest

                                                                        Digest

                                                                      • CRM Marketplace

                                                                        CRM Marketplace

                                                                      • MVP Corner

                                                                        MVP Corner

                                                                      





                                                                      




                                                                          Design. Discuss. Deliver.

                                                                          Create visually engaging stories with Zoho Show.

                                                                          Get Started Now