Using dimension values in set analysis

[#1]

Hi,

I have a static straight table that I would like to use the values from a dimension in my set analysis.  The dimension that I would like to use in this example is [Year].  Is it possible for set analysis to work in this case?

Example:  =SUM( {$<[Finance Year] = {'[Year]'} >} [Revenue])

Where: [Year] is directly from the master calendar, and [Finance Year] & [Revenue] are column names for another table.

Please note: I want to avoid setting [Finance Year] as a dimension.

[phaneendra_kunc]

Hi,

Dont know if i understood your problem correctly..

See if this helps.

1.) create a variable    vYear = Concat(Year,',')

2.) use this variable in your expression.     =SUM( {$<[Finance Year] = {'$(Year)'} >} [Revenue])  

Regards,

Phani

[CELAMBARASAN]

Hi,

     Try with this.

     Sum(Aggr(If(Year=[Financial Year],Sum(Revenue)),[Financial Year]))

Celambarasan

[#4]

Hi Sean,

I am not sure if I understand you clearly. But it sounds to me like you using expressions to obtain the columns [Financial Year] and [Revenue] in that other table. If that's the case why don't you to set them as variables?

Say:

vFinancialYear='Expression used in the other table' and

vRevenue= 'Expression used in the other table'.

You may them try to use  something like:

SUM({$<Year={"$(vFinancialYear)"}>} $(vRevenue))  ?

[#5]

Hi Sean,

I have the same question, did you find a solution yet?

Thanks! Wouter