What does your data look like?
You should be able to add the location into the tooltip if you have the CBSA code in your data. You can add it to the level of detail shelf and then add it when you edit the tooltip.
To clear up the question. I have a data source that has CBSA codes as one of the columns. I would like the tooltip to show the actual CBSA name instead of the code.
For instance: CBSA = 23844 ... I would like tableau tooltip to show: Gary, IN instead of 23844.
You will need a cross reference file code to description (check the Tiger files at census bureau) then join the 2 files on the code