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

Aggregate variables with multiple conditions

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

Posted in reply to sidmech2006

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....




Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation