Cumulative Values based on Current month

[Former Member]

Hi,

I am creating a Webi, where i am creating a measure which gives the sum for a particular month(say April). I am putting a filter on report which compares the Field Month(Cal Year/Month) with month for current date. Hence it is providing me figures for APRIL.

Now, i want the Cumulative figure once the month for current date proceed to any date of May i.e. In month of may i want the measure to give value for APRIL + MAY.

Please help.....

Regards,

Akhil

[Former Member]

Hi Akhil,

Sorry, but I did not get ur requirement.

You want the cumulative sum for all the months beyond the current date or only for the next month.

You can use the RunningSum() function, to get the cumulative sum. Wrap the sum in the If Else Loop so that it starts

summing only after the current month.

If you want only for the next month then you can use Previous() function as:

=Measure+Previous([Measure])

Regards,

Rohit