custom sum

[#1]

Hi All,

I have data like the following :

Date	Amount1	Amount2
Jan. 2014	100	1000
Feb. 2014	150	2000
Mars 2014	200	5000
Apr. 2014	300	3000

I need to create a table where Amount2 of the last month = sum(Amount2) of all the months :

Header 1	Header 2	Header 3
Jan. 2014	100	-
Feb. 2014	150	-
Mars 2014	200	-
Apr. 2014	300	10000

Regards

[#2 · Accepted solution]

found

if(Date=max(ALL Date), sum(TOTAL  Amount2)