Help needed in Crosstab layout preparation

[Nagendar]

Hi Team,

I am trying to create a Crosstab report which looks like a List. Its existing report only. Now trying to add new columns beside to country names.
Plz find the image to get the actual issue.


Thanks.
Nagendar

[New_Guy]

Hi,
What is the desired output format? and just an info, you can build list reports using dimensional data with tuples.
If you hide the row nodes in crosstab by box type none, the cross tab will get disturbed for sure and there is no work around for it. If the output is not excel, you can select the text and do the box type none and make the padding to zero on right and left side.

Option 2 is to build a list report and use tuple like tuple([Netherlands], [Measure]) for each country column.

Let us know if you still need help.

Good luck
New Guy

[Nagendar]

Hi,
What is the desired output format? and just an info, you can build list reports using dimensional data with tuples.
If you hide the row nodes in crosstab by box type none, the cross tab will get disturbed for sure and there is no work around for it. If the output is not excel, you can select the text and do the box type none and make the padding to zero on right and left side.

Option 2 is to build a list report and use tuple like tuple([Netherlands], [Measure]) for each country column.

Let us know if you still need help.

Good luck
New Guy

Hi, 
Thanks for your reply. Its Existing report (Crosstab). Few more columns are needed in that report which are coming from new table. We joined it and trying to add those by inserting crosstab space beside that country--United States..

we want exact output should be like Image 4 in the image which I attached.

Thanks.....

[Nagendar]

Hi, 
Thanks for your reply. Its Existing report (Crosstab). Few more columns are needed in that report which are coming from new table. We joined it and trying to add those by inserting crosstab space beside that country--United States..

we want exact output should be like Image 4 in the image which I attached.


I have tried but I dont want those yellow columns to be in crosstab rows.
Thanks.....