Difference in Crosstab without union and running difference

Hey guys,

I’m looking for a solution in order to display the annual revenue (years = column and revenue = index) for every product (products = row) and the difference of the annual revenue to the previous year (can be column or row) in a crosstab. I would like to avoid generating further queries which I union or using the function running difference. The reason for this is, that I want to use an easy solution in a demo for a customer which can be applied without having a deeper knowledge of Cognos BI Report Studio. If there is no solution, except for the two mentioned, please let me know, that I stopp looking for it.

I’m using a relational database (GO Sales query package from IBM examples) and Cognos 10.1.1.

Thank you very much in advance!


I’m not a report design expert so maybe others might have a better answer, but try these:


Thanks for the answer Grim, but I’m looking for a way to do it without these functions…like a drag n’ drop functionality. For instance, with a dimensional model you could drag the years 2010 and 2011 and say generate a new element with the content of 2011 - 2010.

Ah, ok. This can be done in Transformer for sure using Relative Time Categories for “Previous/Prior Peroid” type stuff.

I can only assume that DMR can do the same.

Thanks for your replay. I will try this now.

Hi Gurus, any idea why my RUNNING-DIFFERENCE summary function failed in validation. Attached is the picture for reference. thanks.

Gurus, attached is additional picture. Thanks.

It looks like you may have some circular logic with [SAYEAR] referencing itself by using [Total(SADEPT1)] in the expression. Try creating the summary in your calculation without references to the auto-calculation, [Total(SADEPT1)]. Your expression will look something like this running-difference([SADEPT1] for [SADISTRICT], [SASTORE], [SAYEAR]).