BookmarkSubscribeRSS Feed
s_j
Calcite | Level 5 s_j
Calcite | Level 5

Hi Friends,

 

I have one query regarding conditional sum in VA.

Suppose I have 4 Fields like Branch, Month, AUM , Net_Sales and have data from jan'16 to jun'16.

If user select any barcnch (Ex: Delhi)  and applies filter on the month field (ex: jan'16 - Mar'16) then my  Net_Sales should be the sum of all the three month starting from jna'16 to mar'16 but aum is mar'16 Number (Doesn't include jan and feb'16 numbers).

 

 

 

3 REPLIES 3
s_j
Calcite | Level 5 s_j
Calcite | Level 5

I am also attaching the screen shot of the final result.

 

Regards,

Sumit

itchyeyeballs
Pyrite | Level 9

Have you created an aggregated measure? (click the arrow to the right of the bin symbol and select aggregated measure)

 

Will look something like 

 

Sum [_ByGroup_] ('measure_name'n)

 

in the text view

s_j
Calcite | Level 5 s_j
Calcite | Level 5

Thanks for your reply.

Yes I had already used aggregated measure but it didn't worked.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 3 replies
  • 2367 views
  • 0 likes
  • 2 in conversation