Crosstab issues

[pelletier44]

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