04 Calculating Dependency Ratios [VBA]

In population studies, we can learn a lot about the population by measuring the relative proportions of each age group (Young, Adult and Old). In the demographic dashboard, we'll use these ratios as our KPI's, and we'll compare the current country to the active region. We'll have two pivot tables, one for the country and the other for the region.