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.
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.
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]).
