sort by coloumn

[dlmsbi]

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.

[dlmsbi]

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"

[dlmsbi]

Thanks I'll try

[amitchandak · Accepted solution]

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