bar chart, accumulate the last month

[dcd123456]

hello

i have a bar chart that show a count by month, the last month is the actual month.

is there anyway to do that the last bar (the actual month) could accumulate the value of the last month and current month.

for example in this table

=monthname(Fecha)	count( DISTINCT Valor)
mar 2013	4
abr 2013	1
may 2013	1
jun 2013	3
jul 2013	3
ago 2013	1
sep 2013	1
oct 2013	1
nov 2013	1
dic 2013	2
ene 2014	2
feb 2014	1
mar 2014	1
abr 2014	3
may 2014	2
jun 2014	1
jul 2014	1

i need that the last bar that represent July 2014  accumulate the value of jun 2014 and jul 2014 and then show value 2 instead of 1.

i have attach an example.

thanks in advance for your help

regards

[tresesco · Accepted solution]

=If(Rowno()<>NoOfRows(), count( DISTINCT Valor), RangeSum( count( DISTINCT Valor),Above(count( DISTINCT Valor))))

Or a bit simpler:

=If(Rowno()<>NoOfRows(), count( DISTINCT Valor), RangeSum( Above(count( DISTINCT Valor),0,2)))

[dcd123456]

Thanks very much for the answer, it works right

regards

dcd