Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.