8 Replies Latest reply on Jul 28, 2017 3:37 AM by Priyabrata Patnaik

how to add row numbwers to a crosstab?

antonio.russo.0 May 23, 2012 8:09 AM

Header 1	Header 2	Header 3
Abc	Abc	Abc
Abc	Abc	Abc
Abc	Abc	Abc

Hello everybody.

I built a crosstab like the above table, now I need to add rownombers on the left side of the table. Is it possible to do add row numbers to obtain a table like the following one?

	Header 2	Header 3	Header 4
1	Abc	Abc	Abc
2	Abc	Abc	Abc
3	Abc	Abc	Abc

I'm trying to do that using a table calculation, with no success.

Thanks

- Antonio

1. Re: how to add row numbwers to a crosstab?

Alex Kerin May 23, 2012 8:52 AM (in response to antonio.russo.0)

You should be able to use index() as a calculation set to discrete on the table.
Like Show 0 Likes(0)

Actions
2. Re: how to add row numbwers to a crosstab?

antonio.russo.0 May 24, 2012 1:08 AM (in response to Alex Kerin)

10x Alex, I succeded using Window_Count, but your solution is better.

Is it possible to hide the header only on the index column?
When I try to do that, all the "rows" headers disapper.
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
3. Re: how to add row numbwers to a crosstab?

sirajmandayippurath May 24, 2012 3:02 AM (in response to antonio.russo.0)

Hi Antonio,

You should be able to right click on the header for the index column and say "Hide Field Label for Rows"

Is that what you wanted?

Regards
Siraj
Like Show 0 Likes(0)

Actions
4. Re: how to add row numbwers to a crosstab?

antonio.russo.0 May 24, 2012 3:14 AM (in response to sirajmandayippurath)

Hi Siraj,
no,"Hide Field Label for Rows" hide all the headers not only the first one.
i.e. in a table like the following one:

I need to hide only the label on the column "Index" and to show the others.
Any suggestion?
Regards,
Antonio.
Like Show 0 Likes(0)

Actions
5. Re: how to add row numbwers to a crosstab?

sirajmandayippurath May 24, 2012 3:26 AM (in response to antonio.russo.0)

Ah! I see what you need and cannot think of a way you can get it done I am afraid.

One workaround I did think of was to name the field itself as a ".". This would create a dot on the column header - but I must admit that it is not a great way to get this functionality. I guess I am going to kick myself for even sending you a recommendation on this one.

Cheers
Siraj
Like Show 0 Likes(0)

Actions
6. Re: how to add row numbwers to a crosstab?

Alex Kerin May 24, 2012 5:47 AM (in response to sirajmandayippurath)

I think the . suggestion is great - best you can do I think
Like Show 0 Likes(0)

Actions
7. Re: how to add row numbwers to a crosstab?

antonio.russo.0 May 24, 2012 5:53 AM (in response to Alex Kerin)

Thanks Siraj.
I thought about using a dot but it isn't a professional solution.
Like Show 0 Likes(0)

Actions
8. Re: how to add row numbwers to a crosstab?

Priyabrata Patnaik Jul 28, 2017 3:37 AM (in response to antonio.russo.0)

You can try to add this sheet to a dashboard and then eventually put an opaque textbox on top of this header to hide it.
Like Show 0 Likes(0)

Actions