If you provide some sample data in cross-tab then It'll be very easy for us to give you proper solution.
Meanwhile you may try something like this
1. Drag your Lat and Long on columns and rows shelf and aggregate it with AVG()
2. Put Location dimension on Details shelf.
3. Put your measure on color,size etc.
Refer the attached package which uses the sample store data and depict the Geo heat map for loss locations.
Hope this helps!!
Geo Heat-Map for losses.twbx 1.2 MB
Please give the data to work on