Conditional Sum

[s_j]

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

[s_j]

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

Regards,

Sumit

[itchyeyeballs]

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]

Thanks for your reply.

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