Help in sorting

[ali_hijazi]

Hello - check attached qvw file

I got a straight table and is giving correct result in terms of sorting

I'm sorting data by Due Date

However when I convert it to pivot table it no more sorts by due date as one of the records is not in the correct position

Please advise on how to make the sorting the same in the two charts  (the pivot table is the one needed)

[MK_QSL]

In straight table, you can sort according to any column.

But in pivot table, you have to sort it first according to the first dimension, then according to the next, etc.

You cannot sort it any way you want.

check enclosed file.

[ali_hijazi]

then why there is an option to sort by expression in the sort tab?

why only record of invoice 83750 comes in the wrong place?

please advise

[MK_QSL]

check attachment in previous reply..

[ali_hijazi]

so we need to sort all previous dimensions by Due date

let me try it on all data

[ali_hijazi]

it didn't work on the original document

what might be wrong?

[MK_QSL]

provide your sample app.. As already said you can't sort same way as straight table in pivot table.

You need to sort by first dimension first and then 2nd dimension and so on..