Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
pls tell the answer
Yes.
Variable vYear: 2015
Expression: sum({<Year={$(vYear)}>}Sales)
Yes you can
SUM({Dimension={$(variable)}}Sales)
Hi Rahul,
sum( {$<Month = {$(vMonth)}>} Sales )
returns the sales for the given Month in relation to current selection.
Yes,
Sure you can use variable in set analysis.
For example: SUM({< Customer_ID={"$(vS1)"} >}Sales)
Here vS1 is the variable name.
I hope this will help you.
Thanks
Yes :
Variable:vCurPrd
Sum({$<WeekId={'>$(=max(WeekId)-(vCurPrd))'}>}trx)
yes you can use. sum({<Year={$(vCurrentYear)}>}Sales)