Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Conditional Sum

Reply
Occasional Contributor s_j
Occasional Contributor
Posts: 6

Conditional Sum

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

 

 

 

Occasional Contributor s_j
Occasional Contributor
Posts: 6

Re: Conditional Sum

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

 

Regards,

Sumit

Frequent Contributor
Posts: 76

Re: Conditional Sum

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

Occasional Contributor s_j
Occasional Contributor
Posts: 6

Re: Conditional Sum

Thanks for your reply.

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

Ask a Question
Discussion stats
  • 3 replies
  • 302 views
  • 0 likes
  • 2 in conversation