Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi,
Try with this.
Sum(Aggr(If(Year=[Financial Year],Sum(Revenue)),[Financial Year]))
Celambarasan
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)) ?
Hi Sean,
I have the same question, did you find a solution yet?
Thanks! Wouter