Cumulative total by day - Chart.

[Revelator80]

I have what seems straightforward in my head but is proving a pain to get into a report. I have created a powercube based on a metadata table which tracks MI returns. For each month, a number of returns are expected and each record is tagged with various dates indicating when it was received, when it was loaded etc. the table looks a bit like this:

ID | Month | DateReceived | DateApproved | DateLoaded... (there are other columns, not relevant)

What I need is, in a chart, for each day of the given month along the x axis, the cumulative number of returns received (and other reports showing approved, loaded etc.)

Any help anybody could give would be greatly appreciated.

Many thanks
David

[CognosPaul]

Since you're using a cube everything need to done with dimensional functions. Take a look at this post for a detail explanation on how to calculate running-totals on dimensional data.