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.

    • Sticky Posts

    • What's New in Zoho Analytics - November 2025

      We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What's
    • What's New in Zoho Analytics - October 2025

      Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! Extreme
    • What’s New in Zoho Analytics – September 2025

      Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded
    • Announcing Agentic AI - Ask Zia!

      We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.
    • Invitation-Based User Access in Zoho Analytics

      Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security