I have come across this strange situation at one of customers. They have bunch of web intelligence reports and one of them is really not working the way they want itseems. Here is the issue;
The report has a cross tab and the measure value is ranked by individual customers. After the ranking the reports needs to sort the values related by each customer (records grouped by customers) say first or last 5 values (materials).
Now the issue is, the ranking is working fine BUT not the sorting. The records are NOT getting sorted properly. This happens only when you combine ranking and sorting.
What is that this customer missing or doing wrong?
Appreciate your inputs.