Aggregate actual Month and prior Month

[#1]

Hi Community,

I have created a bar chart with the value per Month.

Now i want the value of the following month to be an aggregation of the prior month'.

E.g.: February = value(February) + value(Janurary)

Thank you in advance!

Greetings,

Florian

[MK_QSL]

Try this

SUM(Value) + Above(SUM({<Month>}Value))*Avg(1)

[ahaahaaha]

Hi Florian,

Try

RangeSum(Sum(Value), Above(Sum(Value)))

Look attached file.

Regards,

Andrey

[arvind_patil]

Hi Andrey,

It works for me.

Thanks,

Arvind Patil

[#5]

Hey Andrey,

thank you very much, this works.

Is it possible to also aggregate every month before?

E.g.: December = addition of all month

or

         April = value(Jan)+value(Feb) + value(Mar) + value(Apr)

[#6]

Thank you this also works.

[MK_QSL · Accepted solution]

RangeSum(Above(SUM(Value),0,RowNo()))

[#8]

Thank you really much for you help! This is exactly what i needed.

[ahaahaaha]

Look attached file. On your data ID in expression should be replaced by the month number, like Num(Month).