Daconia (White Giant)
| Thursday, July 10, 2008 - 04:42 pm |
The problem is sorting the data. You can create a per capita production column simply by dividing production by pop, but pivot tables will only let you sort and display columns that are in the original data table..so once you have created the new column..you have to go back and paste it into the original and create a NEW pivot table. Then it will be sortable and useful. LOL unless you play with pivot tables much...this is going to be untranslatable isn't it....