Hello,
I have Time dimension with Year, Month. I need cummulative running total for month.
I.e., for current year, Jan contains jan totals. Feb contains Jan+Feb totals and so on. This must be for current year. I know that it can be created by calculated categories but it should be manually maintained every year. Is there any other way to automate it??
Thanks.
Doesn't the date roll up allow for that? I can't remember.
Thanks for your response.
No, it just displays data for each month and then shows the sum of all the months.
What I need is cumulative running total.
Any help is greatly appreciated.
I have the same problem.
The best I can come up with is to create a seperate dimension for Month.
Then create a custom category for Cum Month and a custom descendant for each of the 12 months, each of the months having all required months as its children.
As this is a seperate dim outside of the normal time dim it won't require any manual updating.
For reports just use year from the time dim and then nest Cum Month underneath it.
It is perhaps a little clunky, but it works.
Of course, if anyone has a better idea I'd like to hear it too.