cancel
Showing results for 
Search instead for 
Did you mean: 

Sorting on Alphanumeric column

Rakesh12
Explorer
0 Kudos
349

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
Explorer
0 Kudos

Hi ,

 could you please check now

View Entire Topic
ayman_salem
Active Contributor
0 Kudos

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]))

B_20240907_1.JPG

..

hope it helps

Rakesh12
Explorer
0 Kudos

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
Active Contributor
0 Kudos
Can you give an example so we understand what exactly you mean?
Rakesh12
Explorer
0 Kudos

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.

Rakesh12_0-1725879864548.png

 

 

 

 

 

 

 

 

 

ayman_salem
Active Contributor
0 Kudos
No screenshot visible