Referring to individual values of chart dimension's at x-axis in Set analysis expression

[#1]

Hi All,

I want to use x-axis dimension's each value into an expression.

For example: I have different cities being displayed at my x-axis, so my dimension becomes "City" and individual values which I want to refer to are different cities.

My expression contains a ratio variable which takes numerator from the current table(say Table1) from which I have used the dimension and the denominator will take values from other table(say Table2) which contains column City(say City2) but with different name.

So, I want something like this:

Sum(Population_Table1)/Sum({City2=currentdimension(City)}Population_Table2)

Population_Table1 will automatically take population values for each City but Population_Table2 can not.

[#2]

It is not possible to have dimension value in set definition. Set is resolved before chart calculation ...

Of course there are some possibilities to force this "join". But please tell me, why not to use the same City field in both tables or even why not to concatenate those tables into one?

Life may be easier

regards

Darek