How do I aggregate percentages in a query? Ultimately I want a report that will show percentages on mulitple levels. I have a table with a City field, a Division field and a Region field. Division is like a business unit that includes multiple cities and Region is country/continent that includes multiple Regions (i.e. Europe, North America etc.).
i.e. I want to create a report that will show a worldwide percent and then under that, percentages that comprise that worldwide total for North America and Europe. Even under North America and Europe I want break out the sub-percents that comprise those totals, such as Chicago, San Francisco, London, Paris, etc. Currently I only have percents for the lowest level, which are for the cities I justmentioned. Now I just need to know how to total up to North America, Europe and then worldwide.