Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Aggregate variables with multiple conditions

Reply
Occasional Contributor
Posts: 5

Aggregate variables with multiple conditions

Hi All

 

I am currently putting up a list table where I showcase different aggregated measures. While creating the aggreated measure  I am not able to specify multiple conditions

 

For e.g: (Profit %for Active customers for country id1) = (Sum of Profit for Active cutomers) /(Total Profit) where country_ID=1. So typically I want add this additional where clause but not sure how to mae the same in Report Deisgner.

 

Can anyone help?

 

 

Occasional Contributor
Posts: 13

Re: Aggregate variables with multiple conditions

You can try with multipule "and" Function in (SASVA)order to aggregate more then one condition.

 

Pls find the below attached image let me know if you need more clearity on it....

 

 

Thanks


Capture.PNG
Ask a Question
Discussion stats
  • 1 reply
  • 180 views
  • 0 likes
  • 2 in conversation