Sorting on Alphanumeric column

[Rakesh12]

Hi,

We are facing some issue on sorting in WEBI report. In report we have columns like WBS element data in this columns like CP501 ,FP401,IS802,WP101,WP102,PA701,PA702,PA703 .Here the requirement is when applied sorting the output should result such like WP101,WP102 ,FP401 like that in numerical order . But when i applied sorting it is giving me the output in alpha numerical order like above .Any one could you please apply is that possible to do sorting on alphanumeric column exactly like sorting on numeric column .

please let me know if the question is not clear .

Thanks in advance.

Regards,

Rakesh.

[Rakesh12]

Hi ,

 could you please check now

[ayman_salem · Accepted solution]

the only way to do this is to define a new dimension with only the number, then insert it into the table and sort it according to the column and then hide the column.

define the following variable:

v_ToSort:    =Substr([Item];3;Length([Item]))

..

hope it helps

[Rakesh12 · Accepted solution]

Hi Ayman Salem,

Thanks this works well but when there are no breaks applied in my report. When there are breaks it is not getting applied.

what have to do when breaks applied in my report ?

Thanks

Rakesh

[ayman_salem · Accepted solution]

Can you give an example so we understand what exactly you mean?

[Rakesh12 · Accepted solution]

Hi ayman_salem,

here i am attaching the screenshot for the reference. where the sorting is not reflecting . here i applied breaks for the upwp task.

[ayman_salem · Accepted solution]

No screenshot visible