Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 2 of 2

Data Mapping does not rollup totals from Excel

This is a discussion on Data Mapping does not rollup totals from Excel within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have an excel spreadsheet of customers (one per line) with unique id nos. I have one column of postcode ...

  1. #1
    roberta walker is offline Junior Member White Belt
    Join Date
    Apr 2004
    Posts
    7

    Data Mapping does not rollup totals from Excel

    I have an excel spreadsheet of customers (one per line) with unique id nos. I have one column of postcode areas -which are correct and a column of annual spent (randomly generated whilst I get to grips with things).

    When I create a datamap based on postcode areas it does not rollup all the totals. for example I have about 70 entries for the W area. These total about £7 million (I wish) however in the case of a shaded area map it only brings through the first entry and in the case of a shaded circle map it appears to pick one near the middle.

    I have tried including the ref column, not including the ref column, taking the relevant columns to a new spreadsheet so there are only 2 or 3 to bring thorough - but all to no avail

    The only way I can get it to work is to create a table using sumif in excel (so I have one entry per area) and use this.

    I thought the whole point of the software was to roll up this type of infor for you or am I missing something?

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    Yes, you have to have one record per geography unit you would like to map, it will not do the roll-up for you 'on the fly'. The sumif sounds like a good method, I tend to also use Group By's in Access for this kind of thing.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mapping GPS Data
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 6
    Last Post: 07-24-2009, 10:19 AM
  2. Mapping Zip Code Data
    By mclarke in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 06-15-2007, 11:26 AM
  3. Data Mapping wizard defaults
    By Gary K in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-19-2004, 12:16 PM
  4. MapPoint.NET Data Mapping
    By Anonymous in forum Bing Maps and MapPoint Web Service
    Replies: 1
    Last Post: 10-29-2003, 10:33 AM
  5. mapping data to territories
    By Siteliner in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-10-2003, 05:11 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25