Summing all values with a date less than dimension

[#1]

A simplified version of what I am trying to accomplish:

Data Sample:

Date, Value       

1/1/2012,10

1/2/2012,20

1/3/2012,30

1/4/2012,90

1/5/2012,100

I would like to plot Date on the X Axis.  On the Y axis, I would like to plot the Sum of value where Date <= Dimension value.  For example:  on the date 1/4/2012, i would like to see the value 150.  On 1/2/2012, i would like to see 30.  If I click on a single date i should still be able to see the correct total (ie if i select and dispplay only 1/4/2012 I should still be able to see the value of 150)

I have tried using TOTAL in my sum expressions, but this is plotting the total across all dimension values. 

Please advise.  Thanks,

Andrew

[Gysbert_Wassenaar]

Try: rangesum(above(sum(Value),0,RowNo()))

See attached example

[#3 · Accepted solution]

Try this:

=if(GetSelectedCount(Date)=1,
aggr(rangesum(above(sum({1}Value),0,500)),Date),
rangesum(above(sum(Value), 0, rowno())))

[#4]

Example File.

[#5]

Thanks to you both for the quick replies!