Rank in map visualisation

[anuragmesh1]

hi

i was trying to visualise the products on a map and wanted to show the rank of the selected product in the tooltip. How can i achieve this?

[Chanty4u]

Try this 

'Product Rank: ' & Rank

[anuragmesh1]

hey. actually i dont have a rank column and wanted to rank the products based on their sum of sales. I tried using the rank function but it returns the rank of the states rather than the rank of the products among other products in particular states.

[anuragmesh1]

for example i need to display the rank according to this table on the map for each state and whatever product i select