cross tab

[otsizh]

I haveÃ,  a nested cross tab with 3 levels on the left and 1 on the top. I have to buildÃ,  the left side that all levels would be one onder the other:
Level 1
Level 2
Ã,  Level 3

I tried to do headers and footers, but they don't work quit right. Headers are not visible - so I tried Positioning -> visible -> yes (did not help); to hide some of the headers I tried box-> box type -> none (still show the numbers without headers)

Any suggestions?
thank you!

[sir_jeroen]

Do you want something like this:

[sir_jeroen]

This is done as follows:

1.Ã,  Ã, Add Crosstab
2.Ã,  Ã, Add Categoryname
3.Ã,  Ã, Add Productname
4.Ã,  Ã, Unlock Crosstab
5.Ã,  Ã, Add table (1x2)
6.Ã,  Ã, Move Productname to 2nd row; Categoryname to 1st;
7.Ã,  Ã, Goto Query1 in Query Explorer
8.Ã,  Ã, Move Productname in level 2 to Category in Level 1
9.Ã,  Ã, Delete empty level 2
10. Add some padding etc.

That's it.

I hope I understood you correctly.

Let me know if it worked and if this is what you wanted.

(btw. Sample is made on NorthWind)

[nonamio]

Hi, is it possible to have a null row in the cross tab. As shown in the attached file is it possible to have a row for 'Diary Products' which is blank in all 5 columns.

Thanks,

[sir_jeroen]

I think that's only possible when there's an outer join on  Products table. Otherwise I don't think so....


[Btw.. I'm just creating an animated tutorial on this topic :D]

[sir_jeroen]

And here's the tutorial...

Visit the tutorial @: http://jeroendegraaff.nl/tutorials/

[otsizh]

What I need to be done:
A cross tab with 2 levels on the left with some footers and headers. 1 Project has some business names related to this project. there is supposed to be a title for each group of projects with project number(red). In the end of each group of Project there should be a total of all names assosiated with this project. I have this part but this total apears in the header where I need only the number of the project.

Please see attachment what I have
thanks, Olha   

[sir_jeroen]

So if I understand you correctly... You want the projectnumber (Dimension level) place above 139,100 (Fact)...
Don't think that's possible because you're dealing with facts and dimension. You want a dimension level displayed as fact.

Sorry...

[otsizh]

Thanks anyway....

How to put an image of the report in the here? If a crosstab does not have any numbers or values is it possible to show a message like "there is no data" or any other message insted of empty crosstab?

thanks, olha

[sir_jeroen]

I think you can do that with conditional formatting...