Hey everybody
Can anyone help me out with this?
I've got a crosstab based on a dmr. In the crosstab I have calendar months as columns, accounts as rows and monetary amount as the default measure.
I need to get an accumulative total for each calendar month i.e. p1, p1+p2, P1+p2+p3 etc (p = period). Anyone have any idea how to do this?
Thanks for your help
Wyc
If I'm understanding correctly, you can simply add a query calculation below the accounts with one of the following expressions, depending whether you have a relational or dimensional package:
Relational:
running-total([monetary amount] for [accounts])
Dimensional:
total([monetary amount] within set periodsToDate([package].[Month Dimension].[Month Hierarchy].[All Months level],currentMember([package].[Month Dimension].[Month Hierarchy])))
Cheers!
MF.
Thanks MF as always you're in the know :-)