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!