Calculations on additive data

[codygoodman]

I am trying to produce a column that displays percentages at different levels of aggregation. For example, there is a total group (110000) representing 100% of the data, three digit detailed groups (111000, 112000, and 113000) adding up to 100%, and sub groups (111011 and 111021) that add to 100% of the 3 digit detailed group. The table below is an example of my desired outcome. There are actually 363 records with a total group as 000000 in which all the two digit groups will need to add up to 100%. Any suggestions?

CODE DATA %DATA
110000 500 1
111000 150 0.3
111011 60 0.4
111021 90 0.6
112000 200 0.4
112011 200 1
113000 150 0.3
113031 30 0.2
113054 45 0.3
113057 75 0.5

 

[NARAYANK991]

Hi ,

Just one - please upload a sample workbook.

Narayan

 

[codygoodman]

Here is a sample workbook.

 

[NARAYANK991]

Hi Cody ,

See if this is OK.

Narayan

 

[codygoodman]

This works perfectly. Thank you so much!