Difference in Crosstab without union and running difference

[Arne85]

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!

Arne

[blom0344]

Report Studio is primarily a report developers tool.  Apart from very basic report layouts, you will need the 'deeper' insight pretty quickly. The alternative would be another studio that mainly supports drag and   drop..

[Grim]

You can do Prior Period stuff in Transformer at the model level using Relative Time Categories.

http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cogtr.8.4.0.doc/ug_cogtr_id18081RelativeTimeSettings.html

[Arne85]

Thanks for your answers. I already expected that it won't like in Query Studio for instance. I'll try the relative time categories now.