Sum of field Amount Group until Last Date

[#1]

Hi, I want to make a graphic which shows the total sum of the field [AMOUNT] until the variable LASTDATE but group by the Dimension CalendarMonthAndYear (defined this way : MONTH("Date") & '-' & YEAR("Date")):

For example:

Jan-2011 = 10

Feb-2011=20

Mar-2011=30

The graph should to show

Jan-2011=10

Feb-2011=30

Mar-2011=60

HOw Should I set the sum analysis formula?

any idea?

Thanks and happy weekend

[#2]

Have you tried using Chart Properties > Expressions > Full Accumulation?

[#3 · Accepted solution]

Here is an example.

[#4]

Ok, I`ll try and let you konw. Thanks

[chematos]

If that doesn´t work, try this, although I recommend you to make a master calendar and have fields Year, Month, MonthAndYear.... etc separately

aggr(sum(total Amount), MonthName(Date))

hope this helps

[#6]

Thanks you both for your time!