I am new user of Tableau and I have a problem of summing up the Matching Locations. I want to visualize a sum of records for each country. My data set contains a column called SiteName which cotains duplicates because the record is connected to same site. What I want to do is to visualize a sum of all records that I manually matched for all of the countries. I work with confidential data so I cannot share the content with you but my tableau is set to use:
Longitude as Column
Latitude as Rows
SUM(Number of records) in Colours
SiteName column set to Geo-Country
Is there a way to create a calculation to sum up al the entries for particular latitude and longitude?