How is the data stored ?
Do you have 3 datasources ?
Only one datasource.
Hhhmmm .... I still don't understand the way you're storing the data.
Can you provide a better example, like a spreadsheet ?
If your data looks like this
Country A Country B Measure 1 Measure 2
Singapore Singapore 10 5
India India 7 8
Then you need to do the following calc:
Sum(Measure 1) + Sum (Measure 2)
If you only have one measure column then you need to make sure that the country names match exactly across Country A and Country B.
Can you put both Country A and Country B in rows and send a screen shot please.
I think you need to revisit the data before you start using Tableau.
How was the data created ?
What is the difference between Country A and Country B ?
Also there's issues within both dimensions - AUSTRALIA and Australia are different values and the same with Bangladesh.
Basically, you need to fix the data and sort out the problems there before you start using Tableau. Then the data will be easier to use and it will be easier to do what you want.
That can be fixed by using `upper `method of tableau to convert uppercase like below.
This data is about network services. some times circuit will be installed between two countries(A&B). sometimes it is installed in different location within same country, in that case counry B will be left blank.
here, we need to add like below
ex: 1)total number of circuit ID where country A='Austaralia' +total number of circuit ID where country B='Austaralia'
2)total number of circuit ID where country A='India' +total number of circuit ID where country B='India'
That will give total number of circuit installed in particular country.
I think you need to go back and look at your data as Chris has already mentioned. In the example you show, Algeria is matching up with South Korea which is not correct.
Once this is sorted i would give Tableau another go.
In Such a case try creating a custom SQL as below.
SELECT [Country A],SUM([Measure]) FROM [Table] GROUPBY [Country A]
SELECT [Country B],SUM([Measure]) FROM [Table] GROUPBY [Country B]
If you use this as data source then the Country A and Country B both will become one dimension and then you can SUM the Measure accordingly for the same country.