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).
I am also attaching the screen shot of the final result.
Regards,
Sumit
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
Thanks for your reply.
Yes I had already used aggregated measure but it didn't worked.
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.