SAP Design Studio Crosstab to show Row Number

[former_member237168]

Hello All,

I have a requirement to display data in a horizontal tabular format in Design Studio. For the same, I am using Cross tab component. Unfortunately I am not able to find a way to display the Serial Numbers (Row numbers) in the first column of the crosstab.

We are on Design Studio 1.6 SP4 and backend is BEx query.

KIndly help on how I can achieve to display the row numbers in the crosstab.

[DotEiserman · Accepted solution]

Hi Santosh, I've done something similar by adding in a dynamic rank column into the datasource to dislay in the crosstab. Not sure if this will achieve what you want but worth a try.

Kind regards, Dot

[former_member193885]

You could also look at the Score card component where you have more flexibility in the column positioning.

[MustafaBensan]

Hi Santosh,

This requirement is not supported in the standard Crosstab component. What is your business reason for implementing sequential row numbers?

You might be able to implement your requirement as described in the blog Generate CSS code dynamically in Design Studio with the Community Package.

Regards,

Mustafa.

[former_member237168]

Hi Mustafa,

Thanks for the reply. Requirement is to show a table with more than 100 rows on the dashboard. On the fly user might require to choose top N or Bottom N out of the list. They may not do that analysis also.

So , in a way to easily identify the row numbers if there are as many as 100, they would require the sequential row numbers.

[MustafaBensan]

Hi Santosh,

Thanks for the explanation. I'm not sure that this requirement is so critical for the scenario you've described. Nevertheless, if you want to try to implement it you can review the blog post I have referred to as a possible approach.

Regards,

Mustafa.