C O G N OiSe - the COGNOS community  
03 Sep 2010 07:32:14 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: October 1st, 2009 - COGNOiSe.com now on Linkedin with live News Feed!!! Click here to join the group
 
   Home   Help Search Calendar Login Register  
Pages: [1]
  Print  
Author Topic: Cross-Tab problem  (Read 223 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
Global Moderator
Statesman
*****

Forum Citizenship: +34/-0
Offline Offline

Posts: 303


« 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!