View Full Version : sum post codes
11-04-2011, 03:50 PM
I am a very occasional mappoint user.
WE have some data from our local museum regarding ticket sales and post codes. To get Gift Aid a purchaser records their ticket spend and their post code.
In excel I have each of these transactions (some 2500 over 12 months).
I want to map to postcode areas and show the total ticket spend (not just the FIRST one it comes across for a given postcode) during the 12 months.
I know I can get subtotals in XL but then I am not sure how to map just the subtotals .. I used to be a mapinfo user and mapping totals of transactions depending on afiled (eg postcode was, I think, pretty easy).
How do I do this directly in Mappoint .. I am OK with how to import the raw data.
If you can point me to a tutorial or what words to search by, that wd be great .. or if its straightforward, describe the method.
I see you can "sum by" but not but this is "greyed out" for Post Code areas
11-05-2011, 03:03 AM
OK have got a workaround by creating a pivot table in XL and using that to do the mapping.
But is there a proper way?
11-07-2011, 08:05 AM
MapPoint provides subtotals automatically at different altitudes in a tooltip when you use a data map.
Is that what you're looking for?
11-07-2011, 11:00 AM
Not sure what you mean re "altitudes".
Essentially I have data from museum ticket purchases that also gives the post/zip code with each transaction.
I want to produce a density map based on post/zip code polygons whereby the data is summed automatically by post code boundary.
Subtotals in excel does not work as your are still left with the individual transaction data as well, within the xl table.
But a pivot table does the summing I want.
I wondered if there was a way to get MP to do it.
11-07-2011, 12:53 PM
I meant zoom in or zoom out, then hover mouse over a region.
You should see items with common designation accumulated.
(Your implemetation may not lend itself to this.)
11-07-2011, 10:03 PM
Maybe post a sample dataset with screenshots to show what you want?
I would just comment -- I don't think MapPoint was ever designed to be a ready replacement for all the nifty stuff you can do with data in Excel. For starters, there's no datagrid for the data you've imported. Also, you can't even automate MapPoint without a separate programming environment like Excel macros.
So -- I think doing stuff like pivot tables outside of MapPoint itself is very appropriate. That's just my take.
11-08-2011, 12:51 AM
Thanks for the reply.
Here is a screenshot of the data.
Ticket NumberPostcode Donation (£) MonthYearRegion3162HG £ 9.00 August2009North East3163YO £ 9.00 August2009North East3164NE £ 9.00 August2009North East3165S £ 4.50 August2009East Midlands3166S £ 4.50 August2009East Midlands3167LL £ 9.00 August2009Wales3168NE £ 7.00 August2009North East3169NE £ 4.50 August2009North East3170NE £ 4.50 August2009North East3171TS £ 4.50 August2009North East3172TS £ 4.50 August2009North East3173TS £ 4.50 August2009North East3174TS £ 4.50 August2009North East3175TS £ 4.50 August2009North East3176GU £ 3.50 August2009South East3177SG £ 7.00 August2009South East3178CB £ 9.00 August2009East Midlands
You will see that column 2 refers to Post Code area for which MapPoint has the boundaries. So I want to sum how many people have bought tickets for each area, what the total of al their purchases was in £ and what the average spend was in £/head per postcode area .. might also want to compare different months as well.
I am a long-lapsed user of MapInfo which had superb "layer control" and a very easy way of doing calculations on a dataset.
I don't seem to be able to paste a screenshot of the pivot table.
Can I upload a file in this forum?
Anyway looking forward to getting to grips with MP2011.
Powered by vBulletin® Version 4.2.0 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.
Search Engine Friendly URLs by vBSEO