Author Topic: Cross-Tab problem  (Read 813 times)

Offline morphy

  • Full Member
  • ***
  • Posts: 21
  • Forum Citizenship: +0/-0
Cross-Tab problem
« on: 13 Dec 2009 12: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

Offline PaulM

  • Global Moderator
  • Statesman
  • *****
  • Posts: 584
  • Forum Citizenship: +81/-1
Re: Cross-Tab problem
« Reply #1 on: 13 Dec 2009 04:05:02 pm »
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.