DMR Horizontal Rollup of Members

[wyconian]

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

[MFGF]

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.

[wyconian]

Thanks MF as always you're in the know :-)