Hello Folks,
I have a drop down list month
Mar |
I have a list table in my report area which have 2 columns month and salary
Suppose from drop down list i am selecting Mar then the value should come from jan to mar and rest of the month should get 0 values as seen below.
I want the output as below in SAS VA
Month Salary
Jan 10000
Feb 20000
Mar 30000
Apr 0
May 0
Regards,
Harsh Patel
Hello @harshpatel,
Here's how you can do that.
Step 1: Create a parameter
Step 2: Apply parameter role to Drop-down list
Step 3: Create a new calculated item
Now you can utilize your new measure in the report.
I hope this helps!
Best regards,
Petri
Hello @harshpatel,
Here's how you can do that.
Step 1: Create a parameter
Step 2: Apply parameter role to Drop-down list
Step 3: Create a new calculated item
Now you can utilize your new measure in the report.
I hope this helps!
Best regards,
Petri
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.