Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table like this:
Year Value
2005 400
2006 500
2007 800
2008 300
2009 600
2010 900
2011 700
2012 500
How to make set analysis in List box expression to accumulate Value to be :
Year Value
2005 400
2006 900
2007 1700
2008 2000
2009 2600
2010 3500
2011 4200
2012 4700
Can someone help me?
Thanks,
Danny
rangesum(above( Amount,0,Year))
William
thanks,
The right expression is :
rangesum(above( Value, 0, Year))