on 2024 Sep 07 12:43 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
10 | |
8 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.