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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.