Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can i use variable in set analysis?

pls tell the answer

6 Replies
Gysbert_Wassenaar

Yes.

Variable vYear: 2015

Expression: sum({<Year={$(vYear)}>}Sales)


talk is cheap, supply exceeds demand
Clever_Anjos
Employee
Employee

Yes you can

SUM({Dimension={$(variable)}}Sales)

Not applicable
Author

Hi Rahul,

sum( {$<Month = {$(vMonth)}>} Sales )

returns the sales for the given Month in relation to current selection.

prajapatiamar38
Creator II
Creator II

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

Not applicable
Author

Yes :

Variable:vCurPrd

Sum({$<WeekId={'>$(=max(WeekId)-(vCurPrd))'}>}trx)

Anonymous
Not applicable
Author

yes you can use.  sum({<Year={$(vCurrentYear)}>}Sales)