Need Help with Set Analysis

[#1]

Dear All,

I have 2 tables : 1 is the ciity table contains City, State_ID , Population, GRP on City Level

2 is the State table.

Then the final pivot table I have to make is shown as :

State, GRP on State level,

To Calculate the GRP on State Level - I have to use the set analysis which I am no master of.

GRP on State Level= (GRP on City Level * Population on City level) / Total Population on State Level)

Total Population on State Level= Total Population on City 1+2+... for every citry belong in that state.

Any help will be appreciated.

Thanks

[#2]

Hi Senjaya,

I've made a second load because your example was based on an "In line" table, so I couldn't make the concatenate between the two fields, you can do it in the original charge sentence.

Best regards.