Calculating carry forwarded Month data

[nayanpatel]

Hi Friends,

I have data as given below and i want to calculate carry forwarded sum as an example

For City London For April its 1 for May its 1 and For Jun its 1. Now I want to calculate

If I select Jun 14 then result will be for City London=6 i.e Arp 1 will go to Apr,May,Jun(3) then May's 1 will go to May,Jun(2)

and Jun's 1 will be for Jun only as this is for Jun selection.

If user will select Sep-14 then it will calculate as Apr's 1 will go for Apr, May,Jun,July,Aug,Sep, etc.

City	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14	Oct-14
Japan	0	0	0	0	0	0	0
Mumbai	0	0	0	0	0	0	0
Delhi	0	0	0	0	0	0	0
Newyork	0	0	0	0	2	3	0
Aus	3	3	6	3	4	6	5
Puri	0	0	0	0	0	0	0
SenM	0	0	0	0	0	0	0
Peris	0	0	0	0	1	1	0
London	1	1	1	0	0	0	2
sydney	0	0	0	0	0	0	0
Leeds	0	0	0	0	0	0	0
Birmingham	0	0	0	0	0	0	0

Thanks you

[aaronnash]

EDITED (had it backward):

Nayan,

I think you are looking for an expression that looks like this:

sum

({$ <Date={"<=$(=date(max(Date)))>=$(=addmonths(Min(Date)100))"} >} Entry)

[nayanpatel]

Hi Aaron Tanks for reply,

but its not like that

Its like

Apr May Jun

1       1      1

Then o/p as

Apr May Jun

1     1       1

        1      1

                1

JunTotal= 6