11-21-2016 12:37 AM
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).
11-23-2016 11:49 AM
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