Print Page - Running difference crosstab (DMR)

Title: Running difference crosstab (DMR)
Post by: markoj on 12 Jul 2016 02:04:38 PM

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!

Title: Re: Running difference crosstab (DMR)
Post by: schrotty on 12 Jul 2016 04:16:59 PM

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

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


______[Month]______
[Month][Difference]

Schrotty

Title: Re: Running difference crosstab (DMR)
Post by: markoj on 13 Jul 2016 11:02:43 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: markoj on 12 Jul 2016 02:04:38 PM