BookmarkSubscribeRSS Feed
sidmech2006
Fluorite | Level 6

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?

 

 

2 REPLIES 2
Jatin_Jim
Obsidian | Level 7

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
angeldbracho
Calcite | Level 5

Hey guys, hope you're going well. 

 

I'm having some trouble and I hope you would help. 

I have this data: 

 

MothCode Money  Plan Business Unit
1/1/201952007-              0,50-            569,79A
1/1/201952007-              0,04-            569,79A
1/1/201952007-              0,22-            569,79A
1/1/201952007               1,53-            569,79A
1/1/201952007-              1,23-            569,79A
1/1/201952011-0,71-971,3121737A
1/1/201952011-0,22052-971,3121737A
1/1/20195201110,25-971,3121737A
1/1/2019520112,32-971,3121737A
1/1/201952011-0,95887-971,3121737A
1/1/201952011-0,05-8617,361473B
1/1/201952011-0,00014-8617,361473B
1/1/2019520110,01-8617,361473B
1/1/201952011-0,01-8617,361473B
1/1/201952011-0,02-8617,361473B
1/1/201952011-0,01-8617,361473B
1/1/201952011-0,01-8617,361473B
1/1/201952011-0,01-8617,361473B
1/1/201952011-0,01-8617,361473B
1/1/201952011-0,01-8617,361473B
1/1/201952011-0,01-8617,361473B
1/1/201952016-0,00071-7,278911158B
1/1/201952016-0,00004-7,278911158B

 


As you can see, the value column "PLAN" is the same for each month&code&BusinessUnit. I want to create a crosstab in SAS Visual analytics (7.3) that shows "plan" but I don't know how to not-repeat each plan value or sum it. I mean, if I filter a Code, I would like to see this in SAS: 

 

MonthCode Money  Plan Business Unit
1/1/201952007-              0,46-            569,79A

 

This is, I want SAS to effectively SUM the "money" column, but not sum the "plan" column, just put the value (that repeats in EACH line in the original data).

 

I've been trying and reading lots of things but still can't get it. Anyone knows? Can you help me please?

 

Thank you in advance!!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 2 replies
  • 1809 views
  • 0 likes
  • 3 in conversation