Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
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
check attachment in previous reply..
so we need to sort all previous dimensions by Due date
let me try it on all data
it didn't work on the original document
what might be wrong?
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..