order a table with expression

[igorgois_]

I would like to order a table with a dimension that have duplicated values (see print)

I tried min, max, sum, aggr() but without success

I also tried with dual, but the descriptions became aligned to the right as a number. I need them on the left

Load script example:

load * inline [
kpi_id,kpi_desc,value,order_visual
1,desc1,10,1
2,desc2,20,2
3,desc3,30,3
4,desc2,40,5
5,desc5,50,4
];

Any ideas?

Thanks in advance

[eberhardteduard · Accepted solution]

Hi Igor, see attached print:

p.s: the right table has the answer for your question.

[igorgois_]

Nice job, Eduardo!

But with this solution I can't format the "text" as a number with thousands and decimals 😕

Thank you very much anyway