topic Re: Conditional Sum in SAS Visual Analytics

Conditional Sum

s_j — Mon, 21 Nov 2016 05:37:33 GMT

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

Re: Conditional Sum

s_j — Mon, 21 Nov 2016 05:39:19 GMT

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

Regards,

Sumit

Re: Conditional Sum

itchyeyeballs — Wed, 23 Nov 2016 16:49:44 GMT

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

Re: Conditional Sum

s_j — Thu, 24 Nov 2016 03:38:56 GMT

Thanks for your reply.

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