If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Runing difference on a Crosstab with 3 measures

Started by thedon_1, 24 Feb 2012 09:56:15 AM

Previous topic - Next topic

thedon_1

I have the following crosstab

                                    2011       2012     Difference
UK          Measure 1           10          20         
             Measure 2           30          30
             Measure 3           33%        66%


America  Measure 1            10          20         
            Measure 2            100         100
            Measure 3            10%        20%

I need a difference column which from what I've read, can be acheived using a running difference, unforunately, it only works for one measure.

Any ideas how I can get that difference column to work either using the running difference function in a data item or otherwise?


Thanks

Grim

Quote from: thedon_1 on 24 Feb 2012 09:56:15 AM
I have the following crosstab

                 2011       2012     Difference
UK        Measure 1
           Measure 2


America

Sweet! I can haz xtab too?  :P
"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)

thedon_1

Sorry, accidentaly posted before finishing my message.

Grim

Quote from: thedon_1 on 24 Feb 2012 10:11:15 AM
Sorry, accidentaly posted before finishing my message.

haha, figured as much.  ;)

I'm no report design expert and you mentioned this, but maybe these will help:
http://www-01.ibm.com/support/docview.wss?uid=swg21339373
http://www-01.ibm.com/support/docview.wss?uid=swg21342234

"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)

barrysaab

use expressions below for EX:

running-total([quantity] for [grouping1], [grouping2])

running-total([sales] for [salesman], [region])

Thanks
Boy! Cognos getting on to me!!!

thedon_1

That doesn't work. Due to me having 3 measures, I don't think writring a running difference or running total function will work as that requires me to specify one measure.


thedon_1

Anybody?

This has come up again and i'm still searching for a solution.