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 VA(BrandName 
sony)))- this is wrong

But I want to display the tooltip like this : VA
                         Totalsales($_:7768(City VA(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$

Please help me to How do I do this? 

-- 
You received this message because you are subscribed to the Google Groups 
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to