Forum Discussion

dlmsbi's avatar
dlmsbi
Frequent Visitor
5 years ago
Solved

sort by coloumn

Hi All, I have a question about the next problem: I am try to sort the rows with different coloumn.The problem is i have same word in the coloumn and two different number in the other coloumn. Nor...
  • amitchandak's avatar
    amitchandak
    5 years ago

    dlmsbi , You need to have a column with only one value for szint2

    create a new column and use that

    Sort col = minx(filter(Table, [szint2] = earlier([szint2])),szint2_no)

dlmsbi's avatar
dlmsbi
Frequent Visitor
5 years ago

The result is not bad but not like what i need. (Thanks 🙂)

I need leave alone the [szint2_no] and use the short by coloumn function on [szint2]

 

 

For full pictures: The problem starting a path hierarchie and after i get back the names with lookupvalue and i have a coloumn with order_no. There i have 2 and 1. This is the reason why i can't ordering the "Negyedik szint"