COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: pelletier44 on 22 May 2015 10:22:43 AM

Title: Crosstab issues
Post by: pelletier44 on 22 May 2015 10:22:43 AM
Hello,

I am new to Cognos and am often getting request for something i can't figure out how to do. In this example.. i have the forecast mesure by company ==> lob==> category PER period. (see attachement)

At the bottom i am trying to put budget per period and budget variance per period. I get blank cells since the collums and row coordinates do not have the right logic. The only work around i have figured out is to put another crosstab below with fact cells to line up everything in excel, does not seem ideal. any ideas?

Thanks,
V