Question:
BW Experts,
Need help asap !!!!
I have a sorting problem when I execute my query. It is like I can sort only the field which is in the leftmost column.
Say for example I have 2 fields 'Sr. no'(column 1) & 'Date' (column 2) and 'Sr. no' being the leftmost, now the prob is I can't sort the field in column 2.
Also for every 'Sr.no' I have one 'date'. And I made sure that i did select the right options for sorting order.
Any help in this regard will be highly appreciated.
_________________
Thanks,
M
Answer:
the issue has been solved ... look below for more info if interested !!
Sorting of column 2 always happens within data slice determined for each value in column1.
The workaround could be, as mentioned above, to swap the columns, so that you have date column first and Sr. No as column2.
_________________
Thanks,
M