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.