4 Replies Latest reply on Jun 28, 2012 6:18 AM by Rianna O

    How do I join a table and excel doc to produce a map that shows the sum of a field in the secondary data source?

    Rianna O

      I am joining a table from my internal database (SQL) and an excel document. My goal is to get a filled map that shows the sum of all counts for each code by state (currently it is just picking on of the codes to display the count for each state; not the sum of counts for all codes in that state).  The data does not seem to be rolling up to the state level (example attached).  The problem may be due to the fact that I am joining these data sources by code... but I am not really sure. Any thoughts/suggestions?  It'd be greatly appreciated!