Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am defining some set analysis in a variable like below..
vSetAnalysis
MonthYear={' & chr(39) & '$(vSelectedMonthYear)' & chr(39) &'}
I now need to use this variable in the set analysis in the actual expression like below but i can't get it to work..
Sum({<'$(vSetAnalysis)'>}Sales)
Can anyone help to get this to work please?
Does anyone have any ideas?
Hi
set variable like
vSet=monthyear
then write below set analysis expression in textbox
=Sum({<Monthyear={"=$(vSet)"}>}sales)
or
You can use below expression
=sum({<vSet>}sales)