10 Replies Latest reply: Mar 12, 2010 6:23 AM by Magv RSS

    Need Help  with Set Analysis

      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