How do I grouping data in geochart using tooltip column values?

See more:

Google-Maps

I am using geoChart to display following data in country Map

I have plotted the map using State cloumn and TotalSales($) as value Column

Now ,the tooltip displays like this : ID TotalSales($_113607.00)

I have following summary data in datatable

country State TotalSales($)
------- ------ -------------

USA ID 113607
USA CO 1003460
USA MN 7333040
USA VA 42711

this is my actual data

country State City BrandName TotalSales($)
------- ------ ---- --------- -------------

USA ID Blackfoot sony 100000
USA CO Thornton sony 1003460
USA ID Boise Samsung 6607
USA ID Buhl sony 7000
USA MN Burnsville iPhone 59400
USA VA FairFax sony 7768
USA VA FairFax iPhone 34943
USA MN Gn.Vallley nokia 673940



Now I have added more columns(City,Brandname) to break data from summary data from first table

The tooltip displays like this : VA Totalsales($_:34943(City Fairfax(BrandName sony)))- this is wrong

But I want to display the tooltip like this : VA Totalsales($_:7768(City Fairfax(BrandName sony))) - this is correct

this is my data to display tooltip

country State City BrandName TotalSales($)
------- ------ ---- --------- -------------
USA VA FairFax sony 7768
USA VA FairFax iPhone 34943

From these, what I got is , Geochart takes only last row for display tooltip,but I want to display particular brand's Totalsales i.e sony -7768$

How do I do this?