Add current month and previous month data

[sunitha_chellaiah]

Hi,

I want to add current month data with previous data in pivot table.

Please see the attached screenshot.

For month, I have taken monthnumber i.e. 1,2,3,etc.

I want output as , in monthnumber 2 , monthnumber 1 + monthnumber 2 values addition  should come.

For example: For Ahmedabad, in monthnumber 2 value should come as 250 (126+124).

Experssion used : sum(NOS)

Kindly help me to solve this issue.

Thanks

[mfchmielowski]

Hi.

Do you want to add only one previous or every previous months?

Month2 =month1 +month2

Month3 =month1 +month2 +month3

Month4= month1 +month2 +month3+month4

Etc.? 

[sunitha_chellaiah]

i want to add only one previous  month.

Month2 =month1 +month2

Month3 =month2 +month3

etc.

[mfchmielowski]

Hi

Try then expression: sum(NOS) + if(before(sum(NOS))>0,before(sum(NOS)),0)