Zoho Analytics - Values gets Duplicated

Zoho Analytics - Values gets Duplicated

In Zoho Analytics, I have two tables: one for Country-wise Sales and another for Country-wise Budget with Region. I am attempting to create a stacked bar chart to compare the Region-wise Budget and Sales Revenue.

I have set up a lookup between the two tables, and the chart initially displays the correct values. However, when I apply any filter, the values duplicate, and the revenue figures are wrong.

For example, in my Revenue table, I have Region-wise revenue, and another table includes Country, Region, and Salesperson information. If the revenue for Asia is 100, and the countries involved are India, Japan, and China, the system sums the revenue for all three countries, resulting in 300, which is incorrect.

Can you help me resolve this issue?


Attaching the Screenshot for your references.

This is the underlying data for the chart I created. As you can see, the Middle East & Africa region gets duplicated due to the countries listed in the lookup value column. 


In this screenshot, we can observe that the total values are duplicated because of the countries, leading to a higher value.

    Zoho Campaigns Resources


      • Desk Community Learning Series


      • Digest


      • Functions


      • Meetups


      • Kbase


      • Resources


      • Glossary


      • Desk Marketplace


      • MVP Corner


      • Word of the Day


      • Ask the Experts


        • Sticky Posts

        • What's New in Zoho Analytics - March 2025

          Hello Users, We're back with the latest set of enhancements and improvements aimed at improving your analytics experience. Common Query Table Expression (CTE) support in Query Tables We’ve added support for Common Table Expressions (CTE) in Query Tables,
        • Zoho Analytics in 2024: A look back

          Happy new year to everyone in the Zoho Analytics community! As we welcome 2025, here's a look back of important happenings in 2024.
        • Announcing Zoho Analytics 6.0 Beta!

          We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics team
        • What's New in Zoho Analytics - August 2024

          Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the data
        • We are coming to your city! Zoho Analytics Community Meetup

          Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructing

        Zoho CRM Plus Resources

          Zoho Books Resources


            Zoho Subscriptions Resources

              Zoho Projects Resources


                Zoho Sprints Resources


                  Zoho Orchestly Resources


                    Zoho Creator Resources


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




                          Zoho Writer Writer

                          Get Started. Write Away!

                          Writer is a powerful online word processor, designed for collaborative work.

                            Zoho CRM コンテンツ








                              ご検討中の方

                                • Recent Topics

                                • Generate a link for Zoho Sign we can copy and use in a separate email

                                  Please consider adding functionality that would all a user to copy a reminder link so that we can include it in a personalized email instead of sending a Zoho reminder. Or, allow us to customize the reminder email. Use Case: We have clients we need to
                                • How to associate a document sent in Zoho Sign with an deal in the CRM?

                                  Hi, often documents are loaded in Zoho sign and sent for signature. These sometimes are linked to a deal in the Zoho CRM and would be nice to see the status of the document within the CRM. I am aware of the integration, but that assumes that the document
                                • Preventing auto-redirect to Parent Record on Save...

                                  Our users often create records from the related list on th left side of the screen. They click the blue "plus" button to create the record. This is handy, but for some modules, or situations, they would like to remain on the record AFTER clicking "Save",
                                • CRM Portal Help

                                  Hello, I am trying to set up a portal to connect with our referring doctors to keep patient cases organized. I set up the accounts module as office, the contacts as doctors, the leads as patients, and the deals as treatments. Everything seems to work
                                • Zoho Books (UK) needs to be able to submit a CT600 CTSA return

                                  As well as a VAT Return, most (if not all) small businesses have to submit a CT600 Corporation Tax Self-Assessment. There are many providers who do this (like Xero) bujt not Zoho. Can you add this to the request list please? Many thanks Steve
                                • No image image comes out in the recipient when I sent an email

                                  Hello to the entire forum, when I send an email from Zoho, my profile picture does not come out. On the other hand, if you do, using Gmail accounts. How is it configured to leave ??? Thank you Greetings !!
                                • Zoho Desk & Tasks

                                  Hi, I'd like to be able to create a set of tasks each time a customer request comes in, as I understand it, currently each would need to be create manually. Project is too much of an overhead for what we want to use. Effectively in various use cases we
                                • zet pack not working

                                  We are using the zet pack command to package our Zoho extension. However, after running the command, the extension gets packed, but the resulting package is empty. We've attached a screenshot for reference. Could you please assist us with resolving this
                                • While retrieving the Balance Sheet Report, there is always this "COST OF GOODS SOLD", This is not editable.

                                  Hi Zoho & Readers, While retrieving the Balance Sheet Report, there is always this "COST OF GOODS SOLD", which is reduced from the Sales to arrive at the gross profit. The issue I face here is that Service Oriented Companies don't incur any COGS, hence
                                • Changing salesorder_number via zoho flow

                                  For some reason updating salesorder_number via zoho flow does not stick. Flow is triggered by new sales order filtered by sales channel update sales order: PO#: CX${trigger.reference_number} Salesorder_number: CX${trigger.reference_number} PO# successfully
                                • Working with Products that are non-tangible

                                  How does one create a 'service' in products? Is there a way to disable inventory functions for things like Sofware as a service? The services module doesn't look to be much help either. Not sure how to do this in CRM
                                • Loop in Blueprint but it works. Why? How should this be set?

                                  see picture
                                • Zoho Error: This Operation has been restricted. Please contact support-as@zohocorp.com for further details

                                  Hello There, l tried to verify my domain (florindagoreti.com.br) and its shows this error: This Operation has been restricted. Please contact support-as@zohocorp.com for further details. Screenshot Given Below -  please check what went wrong. Thanks
                                • Bulk Delete Images

                                  How do I bulk Delete Images from Zoho Campaigns. We have been using the Zoho since 2019 and can still only see the option to delete images one by one and we have a lot of old Campaign imagery we don't need anymore. Thanks!
                                • Tip #5: Setting access rights at the subfolder level

                                  Hello everyone, We hope you're finding our WorkDrive Tips and Tricks series useful. For today's tip, we'll teach you how to assign higher subfolder permissions to Team Folder members. Team Folders helps you avoid the drawbacks of traditional file sharing.
                                • I want to update the photo from the mobile app to the product tab product.

                                  I want to update the photo from the mobile app to the product tab product. Because I want to use the CRM product tab for inventory management Contact registration can save photos from the mobile app. Attached screenshot.
                                • Setting default From address when replying to request

                                  At the moment, if I want to reply to a request, the From field has three options, company@zohosupport.com, support@company.zohosupport.com, and support@company.com.  The first two are really internal address that should never be seen by the customer and
                                • Enable Image and Hyperlink Sync in Zoho Desk - Jira Integration

                                  Hi, We are using the Zoho Desk - Jira integration, which allows comments to sync automatically between a Zoho Desk ticket and its linked Jira issue. However, we have noticed a limitation: When adding a hyperlink or image in a Zoho Desk comment, it is
                                • Deluge Function to Update Custom Field

                                  I'm trying to get a Deluge function (which will run as part of a Schedule in Desk) that retrieves all tickets with the status "Recurring" and updates the custom field checkbox "cf_recurring" to "true". Here's what I have, which doesn't work: searchValue
                                • Implement Date-Time-Based Triggers in Zoho Desk

                                  Dear Zoho Desk Support Team, We are writing to request a new feature that would allow for the creation of workflows triggered by specific date-time conditions. Currently, Zoho Desk does not provide native support for date-time-based triggers, limiting
                                • How many ZOHO-Sites does the ZOHO-One Suite allow for?

                                  The free version of ZOHO-Sites allows for two sites, but it seems that the professional version (which is included in the ZOHO-One Suite) only allows for two websites. Is that correct? How many sites can I have within one ZOHO-One account?
                                • Zoho desk Spam Folder

                                  Dear Zoho Support Team, We are experiencing an issue with Zoho Desk, where all emails sent to our customers are being marked as spam. As a result, they are not receiving notifications for new ticket replies. Please assist us in resolving this issue.
                                • Is Zoho Tables part of Zoho One

                                  Cant seem to add the app as part of my Zoho One Subscription?
                                • Canva Integration

                                  Hello! As many marketing departments are streamlining their teams, many have begun utilizing Canva for all design mockups and approvals prior to its integration into Marketing automation software. While Zoho Social has this integration already accomplished,
                                • Possible to filter out contacts that hasn't opened emails in Cadence?

                                  We use Cadences in various outreach - is it possible in analytics or reports to filter out the contacts that have not opened their emails?
                                • On Duty Requests using API

                                  Currently we can only do attendance entries using API, we need to make on Duty Requests using API Use Case We are using different on premise devices to track meetings, we want to sync this data with Zoho People Currently we are manually making on duty
                                • Dialing Microsoft Teams Phone Service via Zoho CRM

                                  I am using the VOIP option in Microsoft teams for my office phone system. I was hoping to have a way to dial numbers directly from Zoho CRM, but don't see anything in the Teams Integration or in the Telephony integration that will enable this. Does anyone
                                • Zoho Books API down

                                  We've been using the zoho books api for the last few weeks to pull open invoices, and the code has stopped working suddenly. When making the same API call as always, we're getting a 400 error.
                                • Issue with ticket replies via Slack: '+' symbols replacing spaces in emails

                                  Hello, support team! We're experiencing an issue when replying to tickets directly through Slack. When the reply is sent to the email, spaces are being replaced by '+' symbols. This makes the message harder to read and understand. Is there any solution
                                • Phonebridge is not visible for one user

                                  Hello Community, i setup phonebridge. It is working for all users in the organisation. Except for one. I uninstalled phonebridge for the user and reinstalled. But the Call button is not appearing in CRM. What could I am missing. ? Many thanks and best
                                • Connecting Portals from different Zoho apps

                                  Hi, I note that Zoho has functionality for customer portals for several of the Zoho apps, like CRM, Projects, Desk etc. Is there any way to connect these portals?  It would be great if we could give our customers access to a portal in which they could
                                • Introducing Keyboard Shortcuts for Zoho CRM

                                  Dear Customers, We're happy to introduce keyboard shortcuts for Zoho CRM features! Until now, you might have been navigating to modules manually using the mouse, and at times, it could be tedious, especially when you had to search for specific modules
                                • Fields are missed from lead generation

                                  Based on the following article, there should be options like "Push leads from all leads forms to Zoho CRM" or "Like my ad" or "Comment on my ad" in the Lead generation menu in my Zoho social, but they are not. Other options are available though. htt
                                • How Can Zoho Help Me Track My Driving Distance and Improve My Routes?

                                  I’ve been using Zoho for a while now, and it’s been great for managing my business tasks. However, I’ve been looking for a way to track my driving habits within Zoho. I’m a regular commuter, and managing my time and routes efficiently is really important
                                • Important: Zoho Campaigns updates on features and functions

                                  Note: Based on our users' and partners' feedback for the below post, we have reverted all the changes mentioned here. We sincerely apologize for any inconvenience caused. Please read this post to understand our goal behind these changes and what's our
                                • Limits on workflow never disclosed, not documents and now being applied. I feel scammed and there is no reply for support.

                                  Hello everyone, I’m facing a critical issue with Zoho Recruit and would appreciate any insights from fellow users or someone from Zoho. For months, I’ve been receiving daily emails stating that I have reached the maximum workflow custom functions limit.
                                • Automatically Open an On-hold Ticket at Prescribed/Scheduled/Delayed Time/Date

                                  We have tickets that require followup depending on the situation. Is there a way to change an open ticket status to an on-hold status and assign a date/time that the ticket will set its status back to open? My use case is scheduling. We schedule work,
                                • Problem with currency field in Zoho CRM

                                  Hi Guys Zoho Books has a feature in currency fields that automatically converts decimal numbers with commas ( , ) to period format ( . ) when pasting them. For example: R$ 2,50 --> R$ 2.50 Is this behavior available in Zoho CRM? I couldn't find any configuration
                                • Zoho CRM Roles to Zoho Desk

                                  I have created my role hierarchy in Zoho CRM, Can i import/sync those roles from CRM to Desk or should i create role hierarchy again in Desk?
                                • Allow the usage of Multi-Select fields as the primary field on "Layout Rules"

                                  We want to force our users to enter some explanation strings when a multi-select field has been utilized. I can't understand the reason for the usage restriction of Multi-Select fields as a primary field. This is a simple "Display hidden mandatory field
                                • Next Page