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.
Normally i know if i try to sort i'm going to get fault message.
Because is as i know it impossible.

 

 

 

The second coloumn sort by third is no problem.

The problem is the last two coloumn. Because example szint2= X  szint2_no= 2 or 1

Somebody know a different way?

 

Thanks.

 

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

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    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"