Need cumulative counts in a bar graph (between two dates)

[#1]

My requirement is i need to do the cumulative count between two date

Initation date to closed date

Example :

A supplier has  over all 10 scar(defects) counts in different months  .  i need to show in the bar graph the  cumulative counts in every month from the initation date to completion date ..

Need help ASAP

[#2]

HI ,

You add month as Dimension and in the Expression add the sum(Defect count)  and select the Full accumulation radio button in the bottom in the same Expression tab.

Regards

Yusuf

[#3]

If a defect is closed then under the month it shound not show up the in the count

[preminqlik]

hi there,

use this expression in UI

rangesum(above(total sum([Defect count]),0,RowNo(total)))

or you can do in back end also as following

table:

Load *,

rangesum([Defect count],peek('Cumulative')) as Cumulative

resident oginal;