Percent of total Measure

[butlerrbrian]

I have demographic data for a CBSA such as Austin, TX, with zones comprising the CBSA, and ZIP codes comprising the zones. Obviously, there is more than just this one CBSA in the table.

I need to sum the households from each ZIP to the zone level, and determine each zone's percentage of the CBSA households.

CBSA Zone Households % of Total
Austin Zone 1 12345 5.46
Austin Zone 2 90123 39.89
Austin Zone 3 123456 54.64

Total 225924

Any input is welcome.