C O G N OiSe - the COGNOS community  
10 Mar 2010 09:53:24 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: February 8th, 2010 - COGNOiSe.com passes 10,000 registered users.
 
   Home   Help Search Calendar Login Register  
Pages: [1]
  Print  
Author Topic: Cross-Tab problem  (Read 107 times)
morphy
Full Member
***

Forum Citizenship: +0/-0
Offline Offline

Posts: 21


« on: 12 Dec 2009 11:26:22 PM »

Hi all,

I created a cross-tab like this one below:



                | 1/3/2009 | 2/3/2009 | 3/3/2009 | .......
--------------
 1 |  engin  |      1          1          1
 2 |   pump |
 3 |  wires   |
 

It works perfectly but now i would like to insert a row above the data of the y-axis in which to write the labels(ID, DESCRIPTION...).

I would like to obtain a cross-tab like this one below:


                 | 1/3/2009 | 2/3/2009 | 3/3/2009 | .......
 ID|   DESCR
----------------
 1 |    engine  |      1          1          1
 2 |    pump   |
 3 |    wires    |


How can I do that?

Thank u all in advanced.

Best Regards.

Matty
Logged
PaulM
Community Leader
*****

Forum Citizenship: +11/-0
Offline Offline

Posts: 149


« Reply #1 on: 13 Dec 2009 03:05:02 AM »

Drag a crosstab space directly to the left of the date node. Unlock, add a text item with to the header. Click on the fact cells of the crosstab space and set box type to none. Click on the crosstab corner and set box type to none.

Repeat for each nested node in rows.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.4 | SMF © 2006-2007, Simple Machines LLC Valid XHTML 1.0! Valid CSS!