If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos Crosstab PreHeader

Started by crazy_tech, 05 Jun 2024 10:42:00 PM

Previous topic - Next topic

crazy_tech

Hi I am developing a cognos report using a Cross tab .. I would like to have 2 headers just like the model below..

     Revenue   Expenses      
   Income   Other   Grocery   Rent   Education
Jan-24   xxxx$   xxxx$   yyy$   yyy$   yyy$
Dec-23   xxxx$   xxxx$   yyy$   yyy$   yyy$
Jan-23   xxxx$   xxxx$   yyy$   yyy$   yyy$

I have all the data in one query called Budget
Income
Other Income
Grocery
Rent
Education

How do i get the first row (text values : revenue And EXpenses). Currently my cross tab looks like below

   Income   Other Grocery   Rent   Education
Jan-24   xxxx$   xxxx$   yyy$   yyy$   yyy$
Dec-23   xxxx$   xxxx$   yyy$   yyy$   yyy$
Jan-23   xxxx$   xxxx$   yyy$   yyy$   yyy$

I tried to insert a row above and add columns but they dont fit the cell size doesnt fit with the row below.Could anyone help me in understanding ..How to add those text values? I would like to mention that i am new to Cognos..