Help with Set Analysis!!!

[educastri83]

Hello community !!


I have a problem I think it's easy but I can not find the solution.


I'll want to create a KPI using a " Text Box " simple expression is:


= Sum ( { < Indicators = ' Economic Value Added ' } > } USD )


You see I have a dimension called "Indicators" but I just want the KPI to show that the result of the indicator ' Economic Value Added '


All good there, the difficulty I have is when I want to apply Set Analysis with variables as vSetQTD , vSetYTD etc .. ..

I don't know like writing the expression. Normally I would with

= Sum ( { < $ ( vSetYTD ) > } USD )


How do I get back my previous expression but only of my indicator " Economic Value Added '


Thank you very much , I think it is simple but I've been mulling over time .


Eduardo

[educastri83]

Hi Vishal!

Variable Value =

PeriodID = {"<=$(=Max(PeriodID))"},

Year = {$(=Max(Year))},

Quarter = ,

Half = ,

Month = ,

Period =