help with set analysis expression

[ramanarayan]

Hi Experts

Need help with an expression please.

In the chart named 'expression help' i have an expression which should give me the sum of demand + sum of demand where month = key + 1. 

I expect to see the value as 350 for the month of Aug.

I tried to use set analysis but i dont get the desired output. Can someone help please

[Somasundaram]

Hi,,

Instead of Set Analysis, You can use Accumulate (in 2 steps)

[agigliotti]

let's try using:
rangesum( above( sum(Demand), 0, RowNo() ) )
as expression

[ramanarayan]

Thanks for the reply.

If you can slightly tweak this expression in such a way that

For Aug, i need Aug+Sept values and for Sept i need Sept + Oct values.

If you can please help modify would be great.

[ramanarayan]

Thanks for the reply.

If you can slightly tweak this expression in such a way that

For Aug, i need Aug+Sept values and for Sept i need Sept + Oct values.

If you can please help modify would be great.