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
Since you're using a cube everything need to done with dimensional functions. Take a look at this post (http://www.cognoise.com/community/index.php?topic=8975.0) for a detail explanation on how to calculate running-totals on dimensional data.