Running difference crosstab (DMR)

[markoj]

Hello all, 

I have a relatively simple problem which I am having trouble solving.

I need to produce a crosstab which has revenue for Country by Months.

like this


              January    February  March   April
Canada       150$      180$       200$   130$
France        150$      100$       200$   130$
USA            350$      480$       400$   630$



I need to produce a crosstab like this

              January  (diff)  February  (diff)   March     (diff)   
Canada       150$            180$       30$      200$      20$         
France        150$             100$      -50$     200$     100$         
USA            350$            480$       -130$     400$    -80$         

I can't get the syntax correctly. Is there something like  (revenue for currentMember(Month) - measure for prevMember(Month)?

Thanks!

[schrotty]

Hi,

In the columbs you have used the Month-level?
Drop aggain the month--level under the first (nest).
Then create a Data item with folliwing calculation:

Code Select Expand

PrevMember(currentMember(hierarchy-name)) - currentMember(hierarchy-name)

Add your new dataitem under the first month-level-item and right beside the second month -level.

Your crosstab column-section will look like this:

Code Select Expand


______[Month]______
[Month][Difference]


Schrotty

[markoj]

 THANK YOU! I lost the whole day yesterday trying to figure this out.