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!
Do you want something like this:
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)
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,
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]
And here's the tutorial...
Visit the tutorial @: http://jeroendegraaff.nl/tutorials/
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
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...
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
I think you can do that with conditional formatting...