Hello,
I have a hierarchy table. Some of the fields are:
LineDescription,LineDescription1, LineDescription2, LineOrder, like that:
[L1,L1, -, 1]
[L11,L1, L11, 1]
[L12,L1, L12, 2]
[L2,L2, -, 2]
[L21,L2, L21, 1]
[L22,L2, L22, 2]
[L23,L2, L23, 3]
and I created a pivot table based on LineDescription1, LineDescription2. I want to sort the table based on LineOrder.
How can I correctly pick the LineOrder for each line? (for more details: http://community.qlik.com/message/713839?et=watches.email.thread#713839)
Thank you!