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